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