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);
}
