private void DoUpdate()
{
int id = 0;
int.TryParse(TxtParameterNo.Text, out id);
var data = new parameterstbl
{
parametersNo = id,
string0 = TxtString0.Text != "" ? TxtString0.Text : "",
string1 = TxtString1.Text != "" ? TxtString1.Text : "",
string2 = TxtString2.Text != "" ? TxtString2.Text : "",
string3 = TxtString3.Text != "" ? TxtString3.Text : "",
string4 = TxtString4.Text != "" ? TxtString4.Text : "",
string5 = TxtString5.Text != "" ? TxtString5.Text : "",
string6 = TxtString6.Text != "" ? TxtString6.Text : "",
string7 = TxtString7.Text != "" ? TxtString7.Text : "",
string8 = TxtString8.Text != "" ? TxtString8.Text : "",
string9 = TxtString9.Text != "" ? TxtString9.Text : "",
modBy = currentUser,
modDate = DatetimeHelper.GetDatetimeNow()
};
var ret = parameterControl.UpdateData(id.ToString(), data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("Data berhasil diubah");
}
else
{
Alert("Gagal mengubah data");
}
}
private void DoSave()
{
var data = new parameterstbl
{
string0 = TxtString0.Text != "" ? TxtString0.Text : "",
string1 = TxtString1.Text != "" ? TxtString1.Text : "",
string2 = TxtString2.Text != "" ? TxtString2.Text : "",
string3 = TxtString3.Text != "" ? TxtString3.Text : "",
string4 = TxtString4.Text != "" ? TxtString4.Text : "",
string5 = TxtString5.Text != "" ? TxtString5.Text : "",
string6 = TxtString6.Text != "" ? TxtString6.Text : "",
string7 = TxtString7.Text != "" ? TxtString7.Text : "",
string8 = TxtString8.Text != "" ? TxtString8.Text : "",
string9 = TxtString9.Text != "" ? TxtString9.Text : "",
creaBy = currentUser,
creaDate = DatetimeHelper.GetDatetimeNow()
};
var ret = parameterControl.AddData(data);
if (ret.Result)
{
ClearFields();
SetLayout(ModeForm.ViewData);
Alert("data berhasil disimpan");
}
else
{
Alert("Gagal menyimpan data");
}
}
protected async void BtnSave_Click(object sender, EventArgs e)
{
try
{
var UploadFolder = HttpContext.Current.Server.MapPath("/Uploads");
string nameFile = userId + "_" + DateTime.Now.ToString("ddMMMyyyy") + Path.GetExtension(FileUpload1.FileName);
//var fileName = Guid.NewGuid().ToString().Replace("-", "_") + Path.GetExtension(FileUpload1.FileName);
var fullName = UploadFolder + "\\" + nameFile;
if (FileUpload1.HasFile)
{
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
var newDetail = new orderanalysisdetailtbl()
{
};
newDetail.fileName = nameFile;
newDetail.fileAttachmentUrl = ConfigurationManager.AppSettings["DefaultBlobRootUrl"] + nameFile;
newDetail.modDate = DateTime.Now;
newDetail.modBy = CommonWeb.GetCurrentUser();
newDetail.orderDetailNo = Convert.ToInt32(txtOrderDetailNo.Text);
var NewItem = new parameterstbl()
{
};
NewItem.string0 = txtBerat.Text;
NewItem.string1 = txtFP.Text;
NewItem.modDate = DateTime.Now;
context.parameterstbls.Add(NewItem);
using (var context = new smlpobDB())
{
context.orderanalysisdetailtbls.Attach(newDetail);
context.Entry(newDetail).Property(x => x.fileAttachmentUrl).IsModified = true;
context.Entry(newDetail).Property(x => x.fileName).IsModified = true;
await context.SaveChangesAsync();
}
context.SaveChanges();
await CloudStorage.BlobPostAsync(FileUpload1.FileBytes, nameFile);
TxtStatus.Text = "Berhasil";
//FileUpload1.SaveAs(fullName);
}
}
catch (Exception ex)
{
TxtStatus.Text = "gagal save --> " + ex.Message;
}
}
public async Task <bool> UpdateData(string id, parameterstbl obj)
{
try
{
if (id != obj.parametersNo.ToString())
{
return(false);
}
using (var context = new smlpobDB())
{
context.parameterstbls.Attach(obj);
context.Entry(obj).Property(x => x.string0).IsModified = true;
context.Entry(obj).Property(x => x.string1).IsModified = true;
context.Entry(obj).Property(x => x.string2).IsModified = true;
context.Entry(obj).Property(x => x.string3).IsModified = true;
context.Entry(obj).Property(x => x.string4).IsModified = true;
context.Entry(obj).Property(x => x.string5).IsModified = true;
context.Entry(obj).Property(x => x.string6).IsModified = true;
context.Entry(obj).Property(x => x.string7).IsModified = true;
context.Entry(obj).Property(x => x.string8).IsModified = true;
context.Entry(obj).Property(x => x.string9).IsModified = true;
context.Entry(obj).Property(x => x.modBy).IsModified = true;
context.Entry(obj).Property(x => x.modDate).IsModified = true;
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
public async Task <bool> AddData(parameterstbl obj)
{
try
{
using (var context = new smlpobDB())
{
context.parameterstbls.Add(obj);
await context.SaveChangesAsync();
return(true);
}
}
catch (Exception ex)
{
LogHelpers.source = this.GetType().Name;
LogHelpers.message = ex.Message;
LogHelpers.user = "";
LogHelpers.WriteLog();
}
return(false);
}
