public DateTime GetNextMonth(DateTime d)
{
string nDate = ConvertNE.ConvertEToN(d);
int[] a = DateStringToInt.StringToInt(nDate);
a[0] = a[0] + 1;
if (a[0] > 12)
{
a[0] = 1;
a[2] = a[2] + 1;
}
else
{
a[2] = a[2];
}
return(DateTime.Parse(ConvertNE.ConvertNToE(a)));
}
protected void btn_insert_Click(object sender, EventArgs e)
{
if (tb_cash.Text == "")
{
tb_cash.Text = "0";
}
//Label1.Text = "";
var url = "url";
var companyName = txtbox_companyName.Text;
var companyName1 = companyName.Substring(0, 10);
var cc = companyName.Length - 10;
var companyName2 = companyName.Substring(10, cc);
var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["CSCommonDB"].ToString());
conn.Open();
var com = new SqlCommand();
com.CommandText = "Insert_Company";
com.Connection = conn;
com.CommandType = CommandType.StoredProcedure;
com.Parameters.AddWithValue("@cName", txtbox_companyName.Text);
com.Parameters.AddWithValue("@regNo", DESEncrypt(txtbox_registrationNo.Text));
com.Parameters.AddWithValue("@panNo", DESEncrypt(txtbox_panNo.Text));
com.Parameters.AddWithValue("@country", DESEncrypt(txtbox_country.Text));
com.Parameters.AddWithValue("@state", DESEncrypt(txtbox_state.Text));
com.Parameters.AddWithValue("@city", DESEncrypt(txtbox_city.Text));
com.Parameters.AddWithValue("@add1", DESEncrypt(txtbox_add.Text));
com.Parameters.AddWithValue("@add2", DESEncrypt(txtbox_add2.Text));
com.Parameters.AddWithValue("@tel", DESEncrypt(txtbox_telephoneNo.Text));
com.Parameters.AddWithValue("@logo", url);
com.Parameters.AddWithValue("@email", DESEncrypt(txtbox_emailAddress.Text));
com.Parameters.AddWithValue("@web", DESEncrypt(txtbox_webAddress.Text));
com.Parameters.AddWithValue("@closingAmt", decimal.Parse(tb_cash.Text));
com.Parameters.AddWithValue("@dates", DateTime.Parse(ConvertNE.ConvertNToE(DateStringToInt.StringToInt(tb_date.Text))));
com.Parameters.AddWithValue("@C1", DESEncrypt(companyName1));
com.Parameters.AddWithValue("@C2", DESEncrypt(companyName2));
com.ExecuteNonQuery();
//insert pic
//FormView1.DataBind();
}
private void ViewDetails(string invoiceNo)
{
mpeDetails.Show();
lblInvoiceNo.Text = invoiceNo;
gvOrderedDetails.DataSource = BllImportExcel.GetImportListByDate(4, int.Parse(ddlBranch.SelectedValue), ddlSeason.SelectedValue, invoiceNo, DateTime.Parse(ConvertNE.ConvertNToE(DateStringToInt.StringToInt(txtDate.Text))));
gvOrderedDetails.DataBind();
}
public void FillGridView()
{
gvOrderList.DataSource = BllImportExcel.GetImportListByDate(3, int.Parse(ddlBranch.SelectedValue), ddlSeason.SelectedValue, "", DateTime.Parse(ConvertNE.ConvertNToE(DateStringToInt.StringToInt(txtDate.Text))));
gvOrderList.DataBind();
}
private void ViewDetails(string orderedId)
{
mpeDetails.Show();
lblOrderNo.Text = orderedId;
gvOrderedDetails.DataSource = BL_OrderedExcel.GetOrderedListByDate(3, int.Parse(ddlBranch.SelectedValue), ddlSeason.SelectedValue, orderedId.ToString(), DateTime.Parse(ConvertNE.ConvertNToE(DateStringToInt.StringToInt(txtDate.Text))));
gvOrderedDetails.DataBind();
}
