/// <summary> /// edit data /// </summary> /// <param name="model"></param> private void EditDataSave(GoAboardModel model) { model.Reason = txtReason.Text; model.Note = txtNote.Text; model.SponsorDepartment = txtSponsorDepartment.Text; model.SourceDepartment = txtSourceDepartment.Text; model.DecisionNumber = txtDecisionNumber.Text; model.DecisionMaker = txtDecisionMaker.Text; model.MakerPosition = hdfIsMakerPosition.Text == @"0" ? cbxMakerPosition.Text : cbxMakerPosition.SelectedItem.Text; if (!string.IsNullOrEmpty(hdfNationId.Text)) { model.NationId = Convert.ToInt32(hdfNationId.Text); } if (!DatetimeHelper.IsNull(dfFromDate.SelectedDate)) { model.StartDate = dfFromDate.SelectedDate; } if (!DatetimeHelper.IsNull(dfToDate.SelectedDate)) { model.EndDate = dfToDate.SelectedDate; } if (!DatetimeHelper.IsNull(dfDecisionDate.SelectedDate)) { model.DecisionDate = dfDecisionDate.SelectedDate; } }
private void DoUpdate() { int id = ParseInt(TxtComodityNo.Text); var data = new comoditytbl { comodityNo = id, comodityName = TxtComodityName.Text, derivativeTo = ParseInt(TxtDerivativeTo.SelectedValue), description = TxtDescription.Text, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; var ret = comodityControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoUpdate() { int id = 0; int.TryParse(TxtStdId.Text, out id); var data = new standarddetailtbl { stdDetailId = id, stdId = ParseInt(TxtStdId.SelectedValue), elementId = Convert.ToInt32(TxtElementCode.SelectedValue), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; var ret = standardDetailControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoSave() { string id = TxtNoBalittanah.Text; var data = new ordersampletbl { noBalittanah = id, orderNo = TxtOrderNo.SelectedValue, sampleCode = TxtSampleCode.Text, countNumber = ParseInt(TxtCountNumber.Text), sampleDescription = TxtDescription.Text, samplingDate = Formater.ToDate(TxtSamplingDate.Text), village = TxtVillage.Text, subDistrict = TxtSubDistrict.Text, district = TxtDistrict.Text, province = TxtProvince.Text, longitude = TxtGps.Text, landUse = TxtLandUSe.SelectedValue, isReceived = TxtIsReceived.SelectedValue, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; var ret = sampleControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoSave() { var data = new standardtbl { stdNo = TxtStdNo.Text, comodityNo = ParseInt(TxtComodityNo.SelectedValue), creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtComodityNo.SelectedValue == "-1") { data.comodityNo = null; } var ret = standardControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoUpdate() { int id = 0; int.TryParse(TxtStdId.Text, out id); var data = new standardtbl { stdId = id, stdNo = TxtStdNo.Text, comodityNo = ParseInt(TxtComodityNo.SelectedValue), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (TxtComodityNo.SelectedValue == "-1") { data.comodityNo = null; } var ret = standardControl.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 elementservicestbl { elementCode = TxtElementCode.Text, analysisTypeName = TxtAnalysisTypeName.SelectedValue, serviceGroup = TxtServiceGroup.Text ?? "", serviceRate = Formater.ToNumber(TxtServiceRate.Text), serviceStatus = TxtServiceStatus.SelectedValue, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; var ret = elementServicesControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoUpdate() { string id = TxtElementCode.Text; var data = new elementservicestbl { elementCode = TxtElementCode.Text, analysisTypeName = TxtAnalysisTypeName.SelectedValue, serviceGroup = TxtServiceGroup.Text ?? "", serviceRate = Formater.ToNumber(TxtServiceRate.Text), serviceStatus = TxtServiceStatus.SelectedValue, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; var ret = elementServicesControl.UpdateData(id, data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
public Model_Template model_InsertEmailEelement(Model_Template el) { int ret = 0; DateTime d = DatetimeHelper._UTCNow(); string filename = d.ToString("ddmmyyyyhhmmss") + ".jpg"; using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(@"INSERT INTO Template (EID,CreatedDate,CreateBy,Title,Description,DemoPath,DemoFileName) VALUES(@EID,@CreatedDate,@CreateBy,@Title,@Description,@DemoPath,@DemoFileName) ; SET @TID = SCOPE_IDENTITY(); ", cn); cmd.Parameters.Add("@EID", SqlDbType.NVarChar).Value = el.EID; cmd.Parameters.Add("@CreatedDate", SqlDbType.SmallDateTime).Value = el.CreatedDate; cmd.Parameters.Add("@CreateBy", SqlDbType.NVarChar).Value = el.CreateBy; cmd.Parameters.Add("@Title", SqlDbType.NVarChar).Value = el.Title; cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = el.Description; cmd.Parameters.Add("@DemoPath", SqlDbType.NVarChar).Value = AppTools.TemplateMockPath(); cmd.Parameters.Add("@DemoFileName", SqlDbType.NVarChar).Value = filename; cmd.Parameters.Add("@TID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); if (ExecuteNonQuery(cmd) > 0) { ret = (int)cmd.Parameters["@TID"].Value; // string fullpath = AppTools.TemplateMockPath() + "test.png"; HtmlToImage.ConvertHtmlToImage(AppTools.TemplateMockPath(), filename, el.EL.html); } el.DemoPath = AppTools.TemplateMockPath(); el.DemoFileName = filename; el.TID = ret; } return(el); }
private void DoSave() { string id = TxtOrderNo.Text; var data = new ordermastertbl { orderNo = id, customerNo = ParseInt(TxtCustomerNo.SelectedValue), comodityNo = ParseInt(TxtComodityNo.SelectedValue), sampleTotal = ParseInt(TxtSampleTotal.Text), priceTotal = Formater.ToNumber(TxtPriceTotal.Text), status = TxtStatus.Text, isPaid = TxtIsPayed.SelectedValue, ApprEvaluator = TxtIsApprove.SelectedValue, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtPic.SelectedValue != "-1") { data.pic = ParseInt(TxtPic.SelectedValue); } var ret = orderControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoSave() { try { var data = new roletbl { roleName = TxtRoleName.Text, description = TxtDescription.Text, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; var ret = roleControl.AddData(data); ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } catch (Exception ex) { LogHelpers.source = this.GetType().Name; LogHelpers.message = ex.InnerException.ToString(); LogHelpers.user = ""; LogHelpers.WriteLog(); Alert("Gagal menyimpan data"); } }
private void DoSave() { string pwd = Crypto.Encrypt(TxtPassword.Text); var data = new accounttbl { username = TxtUsername.Text, password = pwd, roleName = TxtRoleName.SelectedValue, isEmailVerified = "0", creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; var ret = accountControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan 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"); } }
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 employeetbl { employeeName = TxtEmployeeName.Text, position = TxtPosition.Text, employeeEmail = TxtEmpEmail.Text, derivativeToEmployee = ParseInt(TxtDerivativeEmp.SelectedValue), creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtAccountNo.SelectedValue != "-1") { data.accountNo = ParseInt(TxtAccountNo.SelectedValue); } var ret = employeeControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoSave() { var data = new customertbl { customerName = TxtCustomerName.Text, customerEmail = TxtCusEmail.Text, companyName = TxtCompanyName.Text, companyAddress = TxtCompanyAddress.Text, companyPhone = TxtPhoneNo.Text, companyEmail = TxtComEmail.Text, accountNo = ParseInt(TxtAccountNo.SelectedValue), creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow() }; if (TxtAccountNo.SelectedValue != "-1") { data.accountNo = ParseInt(TxtAccountNo.SelectedValue); } var ret = customerControl.AddData(data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("data berhasil disimpan"); } else { Alert("Gagal menyimpan data"); } }
private void DoUpdate() { string id = TxtOrderDetailNo.Text; var data = new orderanalysisdetailtbl { orderDetailNo = ParseInt(id), orderNo = TxtOrderNo.SelectedValue, sampleNo = TxtSampleNo.SelectedValue, elementId = Convert.ToInt32(TxtElementCode), parametersNo = ParseInt(TxtParametersNo.Text), elementValue = TxtElementValue.Text, status = TxtStatus.SelectedValue, recalculate = TxtRecalculate.SelectedValue, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (TxtPic.SelectedValue != "-1") { data.pic = ParseInt(TxtPic.SelectedValue); } var ret = detailControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
public int InsertUserToSesstionRecord(Model_Users ms) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(@"INSERT INTO UserSession (UserID,LastAccessUrl,IPAddress,TimeAccess,LastAccess,Browser,Lang_Id)VALUES(@UserID,@LastAccessUrl,@IPAddress,@TimeAccess,@LastAccess,@Browser,@Lang_Id);SET @UserSessionID = scope_identity()", cn); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = ms.UserID; cmd.Parameters.Add("@LastAccessUrl", SqlDbType.NVarChar).Value = this.CurrentURL; if (HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"] != null) { cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = HttpContext.Current.Request.ServerVariables["HTTP_X_FORWARDED_FOR"].ToString(); } else { cmd.Parameters.Add("@IPAddress", SqlDbType.VarChar).Value = HttpContext.Current.Request.UserHostAddress; } cmd.Parameters.Add("@TimeAccess", SqlDbType.DateTime).Value = DatetimeHelper._UTCNow(); cmd.Parameters.Add("@LastAccess", SqlDbType.DateTime).Value = DatetimeHelper._UTCNow(); cmd.Parameters.Add("@Browser", SqlDbType.NVarChar).Value = HttpContext.Current.Request.Browser.Browser.ToString(); cmd.Parameters.Add("@Lang_Id", SqlDbType.TinyInt).Value = 1; cmd.Parameters.Add("@UserSessionID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); int ret = ExecuteNonQuery(cmd); //HttpContext.Current.Response.Write((int)cmd.Parameters["@SessionId"].Value); //HttpContext.Current.Response.End(); return((int)cmd.Parameters["@UserSessionID"].Value); } }
private void DoUpdate() { int id = ParseInt(TxtEmployeeNo.Text); var data = new employeetbl { employeeNo = id, employeeName = TxtEmployeeName.Text, position = TxtPosition.Text, employeeEmail = TxtEmpEmail.Text, derivativeToEmployee = ParseInt(TxtDerivativeEmp.SelectedValue), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (TxtAccountNo.SelectedValue != "-1") { data.accountNo = ParseInt(TxtAccountNo.SelectedValue); } var ret = employeeControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
public int InsertUserTsAss(Model_UsersTransaction usts) { int ret = 0; using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(@"INSERT INTO UserAssTransaction (UserID,DateSubmit,DownloadCount,Status) VALUES (@UserID,@DateSubmit,@DownloadCount,@Status);SET @TransactionID =SCOPE_IDENTITY()", cn); cmd.Parameters.Add("@UserID", SqlDbType.Int).Value = usts.UserID; cmd.Parameters.Add("@DateSubmit", SqlDbType.SmallDateTime).Value = DatetimeHelper._UTCNow(); cmd.Parameters.Add("@DownloadCount", SqlDbType.Int).Value = 0; cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = true; cmd.Parameters.Add("@TransactionID", SqlDbType.Int).Direction = ParameterDirection.Output; cn.Open(); if (ExecuteNonQuery(cmd) > 0) { ret = (int)cmd.Parameters["@TransactionID"].Value; } } return(ret); }
private void DoUpdate() { int id = ParseInt(TxtAccountNo.Text); var data = new accounttbl { accountNo = id, username = TxtUsername.Text, password = Crypto.Encrypt(TxtPassword.Text), roleName = TxtRoleName.SelectedValue, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; var ret = accountControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
public int InsertOrderPaymentTransferConfirm(Model_OrderPaymentTransferConfirm order) { using (SqlConnection cn = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand(@"INSERT INTO OrderPaymentTransferConfirm (PaymentID,OrderID,Extra,Amount,GateWayID,DatePayment,Status,Name,Email,Phone,FilePath) VALUES(@PaymentID,@OrderID,@Extra,@Amount,@GateWayID,@DatePayment,@Status,@Name,@Email,@Phone,@FilePath)", cn); cmd.Parameters.Add("@PaymentID", SqlDbType.Int).Value = order.PaymentID; cmd.Parameters.Add("@OrderID", SqlDbType.Int).Value = order.OrderID; cmd.Parameters.Add("@Amount", SqlDbType.Decimal).Value = order.Amount; cmd.Parameters.Add("@GateWayID", SqlDbType.Int).Value = order.GateWayID; cmd.Parameters.Add("@Name", SqlDbType.NVarChar).Value = order.Name; cmd.Parameters.Add("@Email", SqlDbType.NVarChar).Value = order.Email; cmd.Parameters.Add("@Phone", SqlDbType.NVarChar).Value = order.Phone; cmd.Parameters.Add("@Extra", SqlDbType.NVarChar).Value = order.Extra; cmd.Parameters.Add("@FilePath", SqlDbType.NVarChar).Value = order.FilePath; cmd.Parameters.Add("@DatePayment", SqlDbType.SmallDateTime).Value = DatetimeHelper._UTCNow(); cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = true; cn.Open(); return(ExecuteNonQuery(cmd)); } }
private void DoUpdate() { int id = ParseInt(TxtCustomerNo.Text); var data = new customertbl { customerNo = id, customerName = TxtCustomerName.Text, customerEmail = TxtCusEmail.Text, companyName = TxtCompanyName.Text, companyAddress = TxtCompanyAddress.Text, companyPhone = TxtPhoneNo.Text, companyEmail = TxtComEmail.Text, modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() }; if (TxtAccountNo.SelectedValue != "-1") { data.accountNo = ParseInt(TxtAccountNo.SelectedValue); } var ret = customerControl.UpdateData(id.ToString(), data); if (ret.Result) { ClearFields(); SetLayout(ModeForm.ViewData); Alert("Data berhasil diubah"); } else { Alert("Gagal mengubah data"); } }
private void DoDuplicate(string NoBalitTanah) { var sampel = DataSampel.Where(x => x.noBalittanah == NoBalitTanah).FirstOrDefault(); if (sampel != null) { DataTable table = new DataTable(); table.Columns.Add("countNumber", typeof(int)); table.Columns.Add("sampleCode", typeof(string)); table.Columns.Add("noBalittanah", typeof(string)); table.Columns.Add("village", typeof(string)); table.Columns.Add("subDistrict", typeof(string)); table.Columns.Add("district", typeof(string)); table.Columns.Add("province", typeof(string)); table.Columns.Add("landUse", typeof(string)); table.Columns.Add("longitude", typeof(string)); table.Columns.Add("latitude", typeof(string)); DataSampel.Add(new ordersampletbl { orderNo = sampel.orderNo, countNumber = DataSampel.Count + 1, sampleCode = "SAMPLE/" + shortid.ShortId.Generate(true, false, 10), noBalittanah = GenerateNoBalitTanah(DataSampel.Count + 1), village = sampel.village, subDistrict = sampel.subDistrict, district = sampel.district, province = sampel.province, landUse = sampel.landUse, longitude = sampel.longitude, latitude = sampel.latitude, creaBy = currentUser, creaDate = DatetimeHelper.GetDatetimeNow(), modBy = currentUser, modDate = DatetimeHelper.GetDatetimeNow() , samplingDate = sampel.samplingDate, sampleDescription = sampel.sampleDescription }); if (DataSampel.Count > 0) { var sort = DataSampel.OrderBy(o => o.countNumber); DataSampel = sort.ToList(); foreach (var data in DataSampel) { table.Rows.Add(data.countNumber, data.sampleCode, data.noBalittanah, data.village, data.subDistrict, data.district, data.province, data.landUse, data.longitude, data.latitude); } } LitJumlahSampel.Text = DataSampel.Count.ToString(); GvData.DataSource = table; GvData.DataBind(); UpdateJumlahContoh(); } }
protected static void CacheData(string key, object data) { if (data != null) { BaseModel <T> .Cache.Insert(key, data, null, DatetimeHelper._UTCNow().AddSeconds(300), TimeSpan.Zero); } }
private void LoadPage() { GenerateAnalisis(); GenerateKomoditas(); GenerateSampleType(); LoadDataGrid(); txtTanggalTerima.Text = DatetimeHelper.GetDatetimeNow().ToString("yyyy-MM-dd"); }
public MediaModel() { // // TODO: Add constructor logic here // this.DateUpload = DatetimeHelper._UTCNow(); }
public Subscription GetCurrentSubscription(int UserId, int PeriodId) { var subscription = _context.Subscriptions .ToList() .Where(x => x.UserId == UserId && DatetimeHelper.IsFromCurrentYear(x.CreatedAt)); var matchSubscription = subscription.First(x => x.PeriodId == PeriodId); return(matchSubscription); }
public static int InsertChildTaxonomy(string param, int priority) { MediaTaxonomy mt = new MediaTaxonomy { Title = param, DatePublish = DatetimeHelper._UTCNow(), Priority = priority }; return(mt.model_InsertChildTaxonomy(mt)); }
/// <summary> /// /// </summary> /// <param name="timeSheetReportModel"></param> private void EditData(TimeSheetReportModel timeSheetReportModel) { timeSheetReportModel.Name = txtName.Text; if (!DatetimeHelper.IsNull(dfFromDate.SelectedDate)) { timeSheetReportModel.StartDate = dfFromDate.SelectedDate; } if (!DatetimeHelper.IsNull(dfToDate.SelectedDate)) { timeSheetReportModel.EndDate = dfToDate.SelectedDate; } }