Beispiel #1
0
        /// <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");
            }
        }
Beispiel #5
0
        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");
            }
        }
Beispiel #6
0
        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");
            }
        }
Beispiel #11
0
        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");
            }
        }
Beispiel #12
0
        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");
            }
        }
Beispiel #16
0
        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);
    }
Beispiel #21
0
        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");
            }
        }
Beispiel #22
0
    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));
        }
    }
Beispiel #23
0
        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");
 }
Beispiel #27
0
    public MediaModel()
    {
        //
        // TODO: Add constructor logic here
        //

        this.DateUpload = DatetimeHelper._UTCNow();
    }
Beispiel #28
0
        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;
     }
 }