Home » Questions » Computers [ Ask a new question ]

c# - How to submit into specific table, because i change two different context , 1 is translate bar and 1 is submit form -

c# - How to submit into specific table, because i change two different context , 1 is translate bar and 1 is submit form -

"Hello i am student i am using c# and asp.net, i have a function that i want to submit a form, while using saveChange it will save all change, in my function i translate data in another context so when i submit form using savechange it will save that translate into database, do you have any idea on this, thank you
public async Task<IActionResult> Registration(IFormCollection form)
{
ViewBag.Lang = await _context.Languages.ToListAsync();
int langId = (Request.Cookies[""Language""] != null && Request.Cookies[""Language""] != """") ? Convert.ToInt32(Request.Cookies[""Language""] + """") : 1;
ViewBag.langId = langId;
ViewBag.Countries = await _context.Country.ToListAsync();
ViewBag.CurrentLang = await _context.Languages.Where(l => l.LangId == langId).FirstOrDefaultAsync();
SetCookie(""Language"", langId + """", 1);
IList<Menu> MenuItems = await _context.Menu.OrderBy(p => p.Order).Where(m => m.MenuGroupId == 1).Include(s => s.SubMenu).ToListAsync();
foreach (Menu menu in MenuItems)
{
// Translate Submenu
string trans = TranslateItem(langId, menu.GetType().ToString(), menu.MenuId, nameof(Menu.Name));
if (trans != null && trans.Trim(' ') != """") menu.Name = trans;
foreach (SubMenu subMenu in menu.SubMenu)
{
trans = TranslateItem(langId, subMenu.GetType().ToString(), subMenu.SubMenuId, nameof(SubMenu.SubMenuName));
if (trans != null && trans.Trim(' ') != """") subMenu.SubMenuName = trans;
}
}
ViewBag.MenuItems = MenuItems;
IOrderedQueryable<OtherLinks> otherLinks = _context.OtherLinks.OrderBy(o => o.OtherLinkOrder);
ViewBag.FooterLinks = otherLinks.Where(p => p.ShowOnFooter).ToList();


string uniqueFileName = """";
string dir = RandomString(12);
string RandomName = RandomString(12);
string base64 = Request.Form[""file_p""];
if (base64 == """")
{
IQueryable<Field> Tempfields = _context.Field
.Include(m => m.Language)
.Include(g => g.GroupFields)
.Where(m => m.DeletedTimestamp == null && m.GroupFields.GroupFieldName == ""Media-Primary"")
.OrderBy(p => p.FieldPage)
.OrderBy(o => o.FieldOrder);

List<Field> tempfields = await Tempfields.ToListAsync();
ViewBag.formFields = tempfields;

ViewBag.message = ""NoPhoto"";
return View();
}
byte[] bytes = Convert.FromBase64String(base64.Split(',')[1]);
var filePath = Path.Combine(Directory.GetCurrentDirectory(), ""wwwroot"", ""uFiles\\uploads\\"", dir);
var formFiles = form.Files;

if (!Directory.Exists(filePath))
{
Directory.CreateDirectory(filePath);
}
var fileNameWithPath = string.Concat(filePath, ""/"", RandomName, "".png"");
uniqueFileName = string.Concat(uniqueFileName, ""uFiles/uploads/"", dir, ""/"", RandomName, "".png"", "";"");
using (FileStream stream = new FileStream(fileNameWithPath, FileMode.Create))
{
stream.Write(bytes, 0, bytes.Length);
stream.Flush();
}

String name = Request.Form[""FirstName""] + Request.Form[""MiddleName""] + Request.Form[""LastName""];
String country = Request.Form[""Country""];
String orginization = Request.Form[""Organization""];

String result = uniqueFileName + ""<NewColumn>"" +
Request.Form[""FirstName""] + ""<NewColumn>"" +
Request.Form[""MiddleName""] + ""<NewColumn>"" +
Request.Form[""LastName""] + ""<NewColumn>"" +
Request.Form[""Dob""] + ""<NewColumn>"" +
Request.Form[""Sex""] + ""<NewColumn>"" +
Request.Form[""Phone""] + ""<NewColumn>"" +
Request.Form[""Fax""] + ""<NewColumn>"" +
Request.Form[""Email""]+ ""<NewColumn>"";

IQueryable<Field> fields = _context.Field
.Include(m => m.Language)
.Include(g => g.GroupFields)
.Where(m => m.DeletedTimestamp == null && m.GroupFields.GroupFieldName == ""Media-Primary"")
.OrderBy(p => p.FieldPage)
.OrderBy(o => o.FieldOrder);

List<Field> formFields = await fields.ToListAsync();
ViewBag.formFields = formFields;

//check to prevend refresh submit old form
bool isFormSubmit = result.Any();
if (isFormSubmit)
{
DateTime? timestamp = DateTime.Now;

// get form fields
Microsoft.Extensions.Primitives.StringValues value = """" ;
List<string> fieldValues = new List<string>();

//To Save dynamic fields
foreach (Field field in formFields)
{

form.TryGetValue(field.FieldName, out value);
string v = value;
result = String.Concat(result, v , ""<NewColumn>"");
};

String final = result;
Registration file = new Registration
{
Status = ""pending"",
Name = name,
Country = country,
Organization = orginization,
FormData = final,
CreatedTimestamp = timestamp,
UpdatedTimestamp = timestamp,
};

_context.Add(file);
await _context.SaveChangesAsync();

ViewBag.message = ""added"";

}

return View();
}






c# asp.net asp.net-mvc asp.net-core-3.1












ShareShare a link to this question Copy linkCC BY-SA 4.0




Follow
Follow this question to receive notifications











asked 2 mins ago





Slack_nySlack_ny

3911 silver badge44 bronze badges"

Asked by: Guest | Views: 95
Total answers/comments: 0