void ResetPassword() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbUserName.Text.Trim())) { ep1.SetError(cmbUserName, "User Name is required."); cmbUserName.Focus(); return; } if (string.IsNullOrEmpty(txtResetPassword.Text.Trim())) { ep1.SetError(txtResetPassword, "Reset password is required."); txtResetPassword.Focus(); return; } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); TL01_USER tblUser = db.TL01_USERs.Single(TL01_USER => TL01_USER.TL01_USERID.ToString() == cmbUserName.SelectedValue.ToString()); tblUser.TL01_PASSWORD = txtResetPassword.Text.Trim(); db.SubmitChanges(); cmbUserName.SelectedIndex = 0; txtResetPassword.Text = ""; Datalayer.InformationMessageBox("Password reset sucesfully."); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
private void button1_Click(object sender, EventArgs e) { if (Datalayer.ShowQuestMsg("Are you sure? Do you want to Send SMS? ")) { int iSend = 0, iNotSend = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (Convert.ToString(dgDisplayData.Rows[i].Cells[0].Value) == "True") { string sMobileNo = dgDisplayData.Rows[i].Cells["MobileNo"].Value.ToString(); string sMSG = dgDisplayData.Rows[i].Cells["Msg"].Value.ToString(); string SMSID = dgDisplayData.Rows[i].Cells["SMSID"].Value.ToString(); int iD = 0; int.TryParse(SMSID, out iD); bool IsSend = SendSMS(sMobileNo, sMSG); if (IsSend) { iSend = iSend + 1; } else { iNotSend = iNotSend + 1; } int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDSMS(iD, DateTime.Now, sMobileNo, sMSG, IsSend, Datalayer.iT001_COMPANYID, ref Iout); } } Datalayer.InformationMessageBox("SMS Send successfully."); } }
void PopualteData() { MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_ALL_ITEM_ON_CHALLENResult> lst = new List <USP_VP_GET_ALL_ITEM_ON_CHALLENResult>(); lst = MyDa.USP_VP_GET_ALL_ITEM_ON_CHALLEN(dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; //dgDisplayData.Columns["TM01_NO"].HeaderText = "No"; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; dgDisplayData.Columns["ChallenQty"].HeaderText = "Qty"; // dgDisplayData.Columns["TM01_NO"].DisplayIndex = 0; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 1; dgDisplayData.Columns["ChallenQty"].DisplayIndex = 2; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
void PopualteData() { MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PRODUCTResult> lstCategory = new List <USP_VP_GET_PRODUCTResult>(); lstCategory = MyDa.USP_VP_GET_PRODUCT("", null, null, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["TM01_PRODUCTID"].Visible = false; dgDisplayData.Columns["TM01_ISSET"].Visible = false; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; dgDisplayData.Columns["TM01_HSNCODE"].HeaderText = "HSN Code"; dgDisplayData.Columns["TM01_PRICE"].HeaderText = "Price"; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgDisplayData.Columns["TM01_NAME"].Width = 500; }
public void FillAccountList(ComboBox cmbAccount, string sType) { Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); if (string.IsNullOrEmpty(sType)) { dtData = dl.SelectMethod("SELECT T001_ACCOUNTID,T001_NAME FROM T001_ACCOUNT WHERE TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY T001_NAME"); } else if (sType == "p") { dtData = dl.SelectMethod("SELECT T001_ACCOUNTID,T001_NAME FROM T001_ACCOUNT WHERE T001_TYPE='PARTY' AND TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY T001_NAME"); } else if (sType == "c") { dtData = dl.SelectMethod("SELECT T001_ACCOUNTID,T001_NAME FROM T001_ACCOUNT WHERE T001_TYPE='CUSTOMER' AND TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY T001_NAME"); } else if (sType == "pl") { dtData = dl.SelectMethod("SELECT T001_ACCOUNTID,T001_NAME FROM T001_ACCOUNT WHERE T001_TYPE='POWERLOOM' AND TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY T001_NAME"); } if (dtData != null && dtData.Rows.Count > 0) { cmbAccount.DataSource = dtData; cmbAccount.DisplayMember = "T001_NAME"; cmbAccount.ValueMember = "T001_ACCOUNTID"; } else { cmbAccount.DataSource = null; } }
void CheckUser() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtUserPassword.Text.Trim())) { ep1.SetError(txtUserPassword, "Password is required.."); txtUserPassword.Focus(); return; } DateTime myDateTime = DateTime.Now; DateTime checkDate1 = DateTime.Parse("2018-05-05"); DateTime checkDate2 = DateTime.Parse("2018-08-25"); //if ((myDateTime >= checkDate1 && myDateTime <= checkDate2) == false) //{ // Datalayer.InformationMessageBox("Demo is expried."); // return; //} MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); var list = (from TL01_USER in MyDa.GetTable <TL01_USER>() where TL01_USER.TL01_PASSWORD == txtUserPassword.Text.Trim() select TL01_USER).ToList(); if (list.Count > 0 && list != null) { //if (DateTime.Now.Month >= 3) //{ // Datalayer.InformationMessageBox("Your Demo is Expire. Please contact to admin."); // this.Close(); //} //if (DateTime.Now.Month <= 2) //{ // Datalayer.InformationMessageBox("Your Demo is Expire. Please contact to admin."); // this.Close(); //} Datalayer.iTL01_USERID = list[0].TL01_USERID; Datalayer.UserType = list[0].TL01_ROLE.ToString(); frmCompanySelection fmMain = new frmCompanySelection(); fmMain.Show(); this.Hide(); // } } else { Datalayer.InformationMessageBox("User name or Password is wrong. please try agin.."); txtUserPassword.Text = ""; txtUserPassword.Focus(); } } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopualteData() { //DAL dl = new DAL(); //DataTable dt = new DataTable(); //dt = dl.SelectMethod("SELECT T007.T007_DATE ,STUFF((SELECT ' Item:'+ CAST( TM01_NAME AS VARCHAR(10))+' Qty:'+CAST(T008_QTY AS VARCHAR(10)) +'\n' [text()] FROM T008_SALEITEM T008 INNER JOIN TM01_PRODUCT TM01 ON TM01.TM01_PRODUCTID = T008.TM01_PRODUCTID WHERE T008.T007_SALEID = T007.T007_SALEID FOR XML PATH(''), TYPE) .value('.','NVARCHAR(MAX)'),1,1,' ') List_Output FROM T007_SALE T007"); //dgDisplayData.DataSource = dt; //dgDisplayData.Columns["List_Output"].DefaultCellStyle.WrapMode = DataGridViewTriState.True; //dgDisplayData.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.AllCells; //return; int iPartyID = 0, TM02_MAIN_PRODUCTSIZEID = 0; string sPartyID = "", sTM02_MAIN_PRODUCTSIZEID = ""; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iPartyID); } //if (!string.IsNullOrEmpty(cmbMainItemSize.Text.Trim())) // int.TryParse(cmbMainItemSize.SelectedValue.ToString(), out TM02_MAIN_PRODUCTSIZEID); if (iPartyID > 0) { sPartyID = iPartyID.ToString(); } if (TM02_MAIN_PRODUCTSIZEID > 0) { sTM02_MAIN_PRODUCTSIZEID = TM02_MAIN_PRODUCTSIZEID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_STOCKResult> lstCategory = new List <USP_VP_GET_STOCKResult>(); lstCategory = MyDa.USP_VP_GET_STOCK(sPartyID, sTM02_MAIN_PRODUCTSIZEID, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; // dgDisplayData.Columns["TM01_NO"].HeaderText = "No"; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; // dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Size"; dgDisplayData.Columns["T006_STOCK"].HeaderText = "Qty"; dgDisplayData.Columns["T006_UNIT"].HeaderText = "Unit"; // dgDisplayData.Columns["TM01_NO"].DisplayIndex = 0; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 0; // dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 2; dgDisplayData.Columns["T006_STOCK"].DisplayIndex = 1; dgDisplayData.Columns["T006_UNIT"].DisplayIndex = 2; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
public static void MakeConnections() { Properties.Settings.Default.Style_King_Dev = sConnStringDLL; Properties.Settings.Default.Save(); MyDabaseDataContext myDA; myDA = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); }
void PopualteData() { string sType = ""; if (!string.IsNullOrEmpty(Convert.ToString(cmbType.Text.Trim()))) { sType = cmbType.SelectedItem.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_ACCOUNTResult> lstCategory = new List <USP_VP_GET_ACCOUNTResult>(); //lstCategory = MyDa.USP_VP_GET_ACCOUNT("", txtName.Text.Trim(), "", sType, "", txtMobileNo.Text.Trim(), Datalayer.iT001_COMPANYID.ToString()).ToList(); lstCategory = MyDa.USP_VP_GET_ACCOUNT("", "", "", "", "", "", Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["T001_ACCOUNTID"].Visible = false; dgDisplayData.Columns["T001_CONTACT_PERSON"].Visible = false; dgDisplayData.Columns["T001_ADDRESS1"].Visible = false; dgDisplayData.Columns["T001_ADDRESS2"].Visible = false; dgDisplayData.Columns["TM_STATEID"].Visible = false; dgDisplayData.Columns["TM_STATEID1"].Visible = false; dgDisplayData.Columns["TM_STATE_NAME"].Visible = false; dgDisplayData.Columns["TM_STATE_CODE"].Visible = false; dgDisplayData.Columns["T001_MOBILE2"].Visible = false; dgDisplayData.Columns["T001_PHONE"].Visible = false; dgDisplayData.Columns["T001_EMAIL"].Visible = false; dgDisplayData.Columns["T001_OPENINGBAL"].Visible = false; dgDisplayData.Columns["T001_GSTTIN"].Visible = false; dgDisplayData.Columns["T001_TIN"].Visible = false; dgDisplayData.Columns["T001_DISCOUNT"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["T001_TYPE"].Visible = false; dgDisplayData.Columns["T001_NAME"].HeaderText = "Name"; dgDisplayData.Columns["T001_MOBILE1"].HeaderText = "Mobile No"; dgDisplayData.Columns["T001_CITY"].Visible = false; dgDisplayData.Columns["T001_NAME"].DisplayIndex = 0; dgDisplayData.Columns["T001_MOBILE1"].DisplayIndex = 1; dgDisplayData.AllowUserToResizeColumns = false; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; //this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; //dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); //dgDisplayData.EnableHeadersVisualStyles = false; //// dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; //dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; //dgDisplayData.ColumnHeadersHeight = 30; //dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); //dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(cmbEmployee.Text.Trim())) { ep1.SetError(cmbEmployee, "Name is Required.."); cmbEmployee.Focus(); return; } if (string.IsNullOrEmpty(txtAmount.Text.Trim())) { ep1.SetError(txtAmount, "Amount is Required.."); txtAmount.Focus(); return; } int T14_WORKERID = 0, TM04_BANKID = 0; decimal dT14_AMOUNT = 0; int.TryParse(cmbEmployee.SelectedValue.ToString(), out T14_WORKERID); decimal.TryParse(txtAmount.Text.Trim(), out dT14_AMOUNT); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_LOAN(Datalayer.iT15_LOANID, T14_WORKERID, dtpDate.Value, dT14_AMOUNT, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT15_LOANID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT15_LOANID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopualteData() { string TM02_PARTYID = ""; int iTM02_PARTYID = 0; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID); } if (iTM02_PARTYID > 0) { TM02_PARTYID = iTM02_PARTYID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_SALARYResult> lst = new List <USP_VP_GET_SALARYResult>(); lst = MyDa.USP_VP_GET_SALARY(TM02_PARTYID, dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; dgDisplayData.Columns["T16_SALARYID"].Visible = false; dgDisplayData.Columns["T14_WORKERID"].Visible = false; dgDisplayData.Columns["T16_TOTAL_DAY"].Visible = false; dgDisplayData.Columns["T16_TOTAL_HOURS"].Visible = false; dgDisplayData.Columns["T16_DAY_PRICE"].Visible = false; dgDisplayData.Columns["T16_HOURS_PRICE"].Visible = false; dgDisplayData.Columns["T16_DETAILS"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["T14_PHONE_NO"].Visible = false; dgDisplayData.Columns["T14_NAME"].HeaderText = "Name"; dgDisplayData.Columns["T16_DATE"].HeaderText = "Date"; dgDisplayData.Columns["T16_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy"; dgDisplayData.Columns["T16_NET_SALARY"].HeaderText = "Salary"; dgDisplayData.Columns["T16_LOAN_AMOUNT"].HeaderText = "Loan"; dgDisplayData.Columns["T14_NAME"].DisplayIndex = 0; dgDisplayData.Columns["T16_DATE"].DisplayIndex = 1; dgDisplayData.Columns["T16_NET_SALARY"].DisplayIndex = 2; dgDisplayData.Columns["T16_LOAN_AMOUNT"].DisplayIndex = 3; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; dgDisplayData.Columns["T14_NAME"].Width = 350; }
void AddUpdateParty() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); decimal T001_OPENINGBAL = 0, T001_DISCOUNT = 0; decimal.TryParse(txtOpeningBal.Text.Trim(), out T001_OPENINGBAL); decimal.TryParse(txtDiscount.Text.Trim(), out T001_DISCOUNT); int TM_STATEID = 0; int.TryParse(cmbState.SelectedValue.ToString(), out TM_STATEID); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_ACCOUNT(Datalayer.iT001_ACCOUNTID, txtName.Text.Trim(), txtContactPerson.Text.Trim(), txtAddress1.Text.Trim(), txtAddress2.Text.Trim(), cmbType.SelectedItem.ToString(), txtCity.Text.Trim(), TM_STATEID, txtMobile1.Text.Trim(), txtMobile2.Text.Trim(), txtPhone.Text.Trim(), txtEmailID.Text.Trim(), T001_OPENINGBAL, txtGSTNo.Text.Trim(), txtTinNo.Text.Trim(), T001_DISCOUNT, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT001_ACCOUNTID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT001_ACCOUNTID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopualteData() { string TM01_PRODUCTID = "", TM02_PRODUCTSIZEID = ""; int iTM01_PRODUCTID = 0, iTM02_PRODUCTSIZEID = 0; if (!string.IsNullOrEmpty(cmbItemName.Text.Trim())) { int.TryParse(cmbItemName.SelectedValue.ToString(), out iTM01_PRODUCTID); } if (iTM01_PRODUCTID > 0) { TM01_PRODUCTID = iTM01_PRODUCTID.ToString(); } if (iTM02_PRODUCTSIZEID > 0) { TM02_PRODUCTSIZEID = iTM02_PRODUCTSIZEID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_TOTAL_ITEM_ON_CHALLENResult> lst = new List <USP_VP_GET_TOTAL_ITEM_ON_CHALLENResult>(); lst = MyDa.USP_VP_GET_TOTAL_ITEM_ON_CHALLEN(dtpFromDate.Value, dtpTodate.Value, TM01_PRODUCTID, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; dgDisplayData.Columns["T001_NAME"].HeaderText = "Customer Name"; dgDisplayData.Columns["T012_NO"].HeaderText = "Challen No"; dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Finish"; dgDisplayData.Columns["T012_DATE"].HeaderText = "Challen Date"; dgDisplayData.Columns["T012_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy"; dgDisplayData.Columns["ChallenQty"].HeaderText = "Qty"; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; dgDisplayData.Columns["T001_NAME"].DisplayIndex = 0; dgDisplayData.Columns["T012_NO"].DisplayIndex = 1; dgDisplayData.Columns["T012_DATE"].DisplayIndex = 2; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 3; dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 4; dgDisplayData.Columns["ChallenQty"].DisplayIndex = 5; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
void PopulateItems() { string sItemNo = txtItemNo.Text.Trim(); int iTM01_PRODUCTID = 0; if (!string.IsNullOrEmpty(txtItemNo.Text.Trim())) { string sItemNumber = txtItemNo.Text.Trim(); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_NOResult> lst = new List <USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_NOResult>(); //lst = MyDa.USP_VP_GET_PRODUCT_FOR_CHALLEN_ON_NO(sItemNumber).ToList(); //if (lst != null && lst.Count > 0) //{ // txtItemName.Text = lst[0].TM01_NAME.ToString(); // lblProductId.Text = lst[0].TM01_PRODUCTID.ToString(); // try // { // lblFinish1.Text = lst[0].TM02_SIZE.ToString(); // txtRate1.Text = lst[0].TM02_PRICE.ToString(); // txtStock1.Text = lst[0].T006_STOCK.ToString(); // lblFinishId1.Text = lst[0].TM02_PRODUCTSIZEID.ToString(); // } // catch // { // } // try // { // lblFinish2.Text = lst[1].TM02_SIZE.ToString(); // txtRate2.Text = lst[1].TM02_PRICE.ToString(); // txtStock2.Text = lst[1].T006_STOCK.ToString(); // lblFinishId2.Text = lst[1].TM02_PRODUCTSIZEID.ToString(); // } // catch // { // } //} //else //{ // ReseItemDetails(); // Datalayer.InformationMessageBox(sItemNo + " not exist"); //} } else { errorProvider1.SetError(txtItemNo, "Item number is required.."); txtItemNo.Focus(); return; } }
void PopualteData() { string TM02_PARTYID = ""; int iTM02_PARTYID = 0; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iTM02_PARTYID); } if (iTM02_PARTYID > 0) { TM02_PARTYID = iTM02_PARTYID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PACKING_SLIPResult> lst = new List <USP_VP_GET_PACKING_SLIPResult>(); lst = MyDa.USP_VP_GET_PACKING_SLIP(null, TM02_PARTYID, null, dtpFromDate.Value, dtpTodate.Value, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; dgDisplayData.Columns["T010_PACKINGSLIPID"].Visible = false; dgDisplayData.Columns["T001_ACCOUNTID"].Visible = false; dgDisplayData.Columns["T001_NAME"].HeaderText = "Name"; dgDisplayData.Columns["T001_MOBILE1"].HeaderText = "Mobile No"; dgDisplayData.Columns["T010_DATE"].HeaderText = "Date"; dgDisplayData.Columns["T010_DATE"].DefaultCellStyle.Format = "dd-MM-yyyy"; dgDisplayData.Columns["T010_NO"].HeaderText = "Slip No"; dgDisplayData.Columns["T010_TRANSPORT"].HeaderText = "Transport"; dgDisplayData.Columns["T010_LRNO"].HeaderText = "L.R. No"; dgDisplayData.Columns["T001_NAME"].DisplayIndex = 0; dgDisplayData.Columns["T001_MOBILE1"].DisplayIndex = 1; dgDisplayData.Columns["T010_DATE"].DisplayIndex = 2; dgDisplayData.Columns["T010_NO"].DisplayIndex = 3; dgDisplayData.Columns["T010_TRANSPORT"].DisplayIndex = 4; dgDisplayData.Columns["T010_LRNO"].DisplayIndex = 5; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; this.dgDisplayData.ColumnHeadersDefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
void PopualteData() { int iPartyID = 0; string sPartyID = ""; if (!string.IsNullOrEmpty(cmbName.Text.Trim())) { int.TryParse(cmbName.SelectedValue.ToString(), out iPartyID); } if (iPartyID > 0) { sPartyID = iPartyID.ToString(); } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_PRODUCT_SIZEResult> lstCategory = new List <USP_VP_GET_PRODUCT_SIZEResult>(); lstCategory = MyDa.USP_VP_GET_PRODUCT_SIZE("", sPartyID, null, null, Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lstCategory; dgDisplayData.Columns["TM01_PRODUCTID"].Visible = false; dgDisplayData.Columns["TM01_PRODUCTID1"].Visible = false; dgDisplayData.Columns["TM01_ISSET"].Visible = false; dgDisplayData.Columns["TM02_PRODUCTSIZEID"].Visible = false; dgDisplayData.Columns["TM01_PRODUCTID"].Visible = false; dgDisplayData.Columns["TM01_HSNCODE"].Visible = false; dgDisplayData.Columns["TM01_TAX_RATE"].Visible = false; dgDisplayData.Columns["TM_COMPAYID"].Visible = false; dgDisplayData.Columns["TM_COMPAYID1"].Visible = false; dgDisplayData.Columns["TM01_NO"].HeaderText = "No"; dgDisplayData.Columns["TM01_NAME"].HeaderText = "Name"; dgDisplayData.Columns["TM02_SIZE"].HeaderText = "Size"; dgDisplayData.Columns["TM02_PRICE"].HeaderText = "Price"; dgDisplayData.Columns["TM01_NO"].DisplayIndex = 0; dgDisplayData.Columns["TM01_NAME"].DisplayIndex = 1; dgDisplayData.Columns["TM02_SIZE"].DisplayIndex = 2; dgDisplayData.Columns["TM02_PRICE"].DisplayIndex = 3; this.dgDisplayData.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill; dgDisplayData.ColumnHeadersDefaultCellStyle.BackColor = Color.FromArgb(Datalayer.sGridHeaderColor1, Datalayer.sGridHeaderColor2, Datalayer.sGridHeaderColor3); dgDisplayData.EnableHeadersVisualStyles = false; // dgCategory.CurrentRow.DefaultCellStyle.BackColor = Color.White; dgDisplayData.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing; dgDisplayData.ColumnHeadersHeight = 30; dgDisplayData.ColumnHeadersDefaultCellStyle.Font = new System.Drawing.Font("Tahoma", 12F, FontStyle.Bold, GraphicsUnit.Pixel); dgDisplayData.ColumnHeadersDefaultCellStyle.ForeColor = Color.White; }
void AddUpdateParty() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); decimal T14_DAY_PRICE = 0, T14_HOURS_PRICE = 0; decimal.TryParse(txtDayPrice.Text.Trim(), out T14_DAY_PRICE); decimal.TryParse(txtHoursPrice.Text.Trim(), out T14_HOURS_PRICE); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_WORKER(Datalayer.iT14_WORKERID, txtName.Text.Trim(), txtAddress1.Text.Trim(), txtMobile1.Text.Trim(), T14_DAY_PRICE, T14_HOURS_PRICE, txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iT14_WORKERID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iT14_WORKERID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } decimal TM01_TAX_RATE = 0; decimal.TryParse(txtTaxRate.Text.Trim(), out TM01_TAX_RATE); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_PRODUCT(Datalayer.iTM01_PRODUCTID, txtNo.Text.Trim(), txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), TM01_TAX_RATE, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM01_PRODUCTID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM01_PRODUCTID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopulateUser() { db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); var lst = (from u in db.TL01_USERs select u).ToList(); if (lst != null && lst.Count > 0) { cmbUserName.DataSource = lst; cmbUserName.DisplayMember = "TL01_USERNAME"; cmbUserName.ValueMember = "TL01_USERID"; } else { cmbUserName.DataSource = null; } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_EXPENSE(Datalayer.iTM05_EXPENSEID, txtName.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.iTM05_EXPENSEID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.iTM05_EXPENSEID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
public void FillStateList(ComboBox cmbstate) { Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); dtData = dl.SelectMethod("SELECT TM_STATEID,TM_STATE_CODE +' - '+ TM_STATE_NAME AS ProductName FROM TM_STATE ORDER BY TM_STATEID"); if (dtData != null && dtData.Rows.Count > 0) { cmbstate.DataSource = dtData; cmbstate.DisplayMember = "ProductName"; cmbstate.ValueMember = "TM_STATEID"; } else { cmbstate.DataSource = null; } }
public void FillEmployeeList(ComboBox cmbEmployee) { Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); dtData = dl.SelectMethod("SELECT T14_WORKERID,T14_NAME FROM T14_WORKER WHERE TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY T14_NAME"); if (dtData != null && dtData.Rows.Count > 0) { cmbEmployee.DataSource = dtData; cmbEmployee.DisplayMember = "T14_NAME"; cmbEmployee.ValueMember = "T14_WORKERID"; } else { cmbEmployee.DataSource = null; } }
public void FillExpenseMaster(ComboBox cmbExpense) { Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); dtData = dl.SelectMethod("SELECT TM05_EXPENSEID,TM05_EXPENSE FROM TM05_EXPENSE WHERE TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY TM05_EXPENSE"); if (dtData != null && dtData.Rows.Count > 0) { cmbExpense.DataSource = dtData; cmbExpense.DisplayMember = "TM05_EXPENSE"; cmbExpense.ValueMember = "TM05_EXPENSEID"; } else { cmbExpense.DataSource = null; } }
public void FillItemSetName(ComboBox cmbItemSetName) { Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); dtData = dl.SelectMethod("SELECT TM01_PRODUCTID,TM01_NAME AS ProductName FROM TM01_PRODUCT WHERE TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY TM01_NAME"); if (dtData != null && dtData.Rows.Count > 0) { cmbItemSetName.DataSource = dtData; cmbItemSetName.DisplayMember = "ProductName"; cmbItemSetName.ValueMember = "TM01_PRODUCTID"; } else { cmbItemSetName.DataSource = null; } }
void AddUpateBank() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtBank.Text.Trim())) { ep1.SetError(txtBank, "Name is Required.."); txtBank.Focus(); return; } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADDUPDATE_BANK(Datalayer.T010_PACKINGSLIPID, txtBank.Text.Trim(), txtAccount.Text.Trim(), txtIFSC.Text.Trim(), txtBranch.Text.Trim(), txtDetails.Text.Trim(), Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.UpdateMessageBox(sPageName); } } else { if (Datalayer.T010_PACKINGSLIPID == 0) { Datalayer.DosenotInsertMessageBox(sPageName); } else { Datalayer.DosenotUpdateMessageBox(sPageName); } } ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void AddUser() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtOldPassword.Text.Trim())) { ep1.SetError(txtOldPassword, "Old Password is requied."); txtOldPassword.Focus(); return; } if (string.IsNullOrEmpty(txtPassword.Text.Trim())) { ep1.SetError(txtPassword, "Password is requied."); txtPassword.Focus(); return; } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); var lst = (from u in db.TL01_USERs select u).Where(s => s.TL01_USERID == Datalayer.iTL01_USERID).ToList(); if (lst != null && lst.Count > 0) { if (lst[0].TL01_PASSWORD.ToString() != txtOldPassword.Text.Trim()) { Datalayer.InformationMessageBox("Old password is not correct.."); txtOldPassword.Focus(); return; } } db = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); TL01_USER tlUser = new TL01_USER(); tlUser.TL01_PASSWORD = txtPassword.Text.Trim(); tlUser.TL01_ROLE = "User"; db.TL01_USERs.InsertOnSubmit(tlUser); db.SubmitChanges(); txtPassword.Text = ""; txtPassword.Focus(); Datalayer.InsertMessageBox(sPageName); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
void PopualteData() { Boolean bStatus = false; if (!string.IsNullOrEmpty(comboBox1.Text.Trim())) { if (comboBox1.SelectedItem.ToString() == "Send") { bStatus = true; } } MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); List <USP_VP_GET_SMSResult> lst = new List <USP_VP_GET_SMSResult>(); lst = MyDa.USP_VP_GET_SMS(dtpDate.Value, bStatus.ToString(), Datalayer.iT001_COMPANYID.ToString()).ToList(); dgDisplayData.DataSource = lst; }
private void btnAdd_Click(object sender, EventArgs e) { if (dgDisplayData.Rows.Count == 0) { Datalayer.InformationMessageBox("Please select customer "); return; } if (Datalayer.ShowQuestMsg("Are you sure? Do you want to Send SMS? ")) { int iSend = 0, iNotSend = 0; for (int i = 0; i < dgDisplayData.Rows.Count; i++) { if (Convert.ToString(dgDisplayData.Rows[i].Cells[0].Value) == "True") { string sMobileNo = dgDisplayData.Rows[i].Cells["T001_MOBILE1"].Value.ToString(); string sName = dgDisplayData.Rows[i].Cells["T001_NAME"].Value.ToString(); string sAmount = dgDisplayData.Rows[i].Cells["TOTALPENDING"].Value.ToString(); string sCompanyName = dgDisplayData.Rows[i].Cells["TM_NAME"].Value.ToString(); string sPhoneNo = dgDisplayData.Rows[i].Cells["TM_PHONENO"].Value.ToString(); string sMSG = "Dear, " + sName + " your pending amount payable to " + sCompanyName + " is Rs." + sAmount + " and it is now overdue. Please Contact us on " + sPhoneNo + " urgently to discuss our policy."; bool IsSend = SendSMS(sMobileNo, sMSG); if (IsSend) { iSend = iSend + 1; } else { iNotSend = iNotSend + 1; } int?Iout = 0; MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); MyDa.USP_VP_ADDSMS(0, DateTime.Now, sMobileNo, sMSG, IsSend, Datalayer.iT001_COMPANYID, ref Iout); } } Datalayer.InformationMessageBox("SMS Send successfully."); lblTotalSend.Text = "Total Send SMS:" + iSend.ToString(); lblNotSend.Text = "Total Not Send SMS:" + iNotSend.ToString(); } }
void AddUpdateData() { try { ep1.Clear(); if (string.IsNullOrEmpty(txtName.Text.Trim())) { ep1.SetError(txtName, "Name is Required.."); txtName.Focus(); return; } decimal dTM02_PRICE1 = 0, dTM02_PRICE2 = 0; decimal.TryParse(txtPrice.Text.Trim(), out dTM02_PRICE1); int iTM02_PRODUCTSIZEID1 = 0, iTM02_PRODUCTSIZEID2 = 0; int.TryParse(lblSizeId1.Text.Trim(), out iTM02_PRODUCTSIZEID1); int.TryParse(lblSizeId2.Text.Trim(), out iTM02_PRODUCTSIZEID2); MyDa = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); int?Iout = 0; MyDa.USP_VP_ADD_PRODUCT(Datalayer.iTM01_PRODUCTID, txtName.Text.Trim(), chkIsSet.Checked, txtHSNCode.Text.Trim(), dTM02_PRICE1, Datalayer.iT001_COMPANYID, ref Iout); if (Iout > 0) { Datalayer.InsertMessageBox(sPageName); } else { Datalayer.DosenotInsertMessageBox(sPageName); } PopualteData(); ResetData(); } catch (Exception ex) { Datalayer.WorningMessageBox(ex.Message.ToString(), "Error"); } }
public decimal GetItemPrice(ComboBox cmbItemSize) { int TM02_PRODUCTSIZEID = 0; decimal dTM02_PRICE = 0; if (!string.IsNullOrEmpty(cmbItemSize.Text.Trim())) { int.TryParse(cmbItemSize.SelectedValue.ToString(), out TM02_PRODUCTSIZEID); Myda = new MyDabaseDataContext(Properties.Settings.Default.Style_King_Dev); DataTable dtData = new DataTable(); dtData = dl.SelectMethod("SELECT TM02_PRICE FROM TM02_PRODUCTSIZE WHERE TM02_PRODUCTSIZEID=" + TM02_PRODUCTSIZEID + "AND TM_COMPAYID='" + Datalayer.iT001_COMPANYID.ToString() + "' ORDER BY TM01_NO"); if (dtData != null && dtData.Rows.Count > 0) { decimal.TryParse(dtData.Rows[0][0].ToString(), out dTM02_PRICE); } } return(dTM02_PRICE); }