//زر الإضافة في جدول التفاصيل
protected void Btn_Add_Details_Click(object sender, EventArgs e)
{
if (Txt_Disc1_Prct.Text == "")
{
Txt_Disc1_Prct.Text = "0";
}
//رقم السطر
New_Ln_No();
//الاضافة
SqlCommand cmd = new SqlCommand("INSERT INTO [InvLoddtl] ([Cmp_No], [Actvty_No], [StoreID], [Doc_Ty], [Doc_No], [Ln_No], [Doc_Dt], [Doc_DtAr], [Reftyp_No], [Pym_No], [To_Store], [Unit_No], [Qty], [Exp_Date], [Itm_Pur], [Titm_Pur], [Itm_Sal], [Titm_Sal], [Disc1_Prct], [Disc1_Val], [FcItm_Pur], [FcTitm_Pur], [Batch_No], [Taxp_Extra], [Taxv_Extra], [Sup_No], [Loc_No], [Itm_No]) VALUES (@Cmp_No, @Actvty_No, @StoreID, @Doc_Ty, @Doc_No, @Ln_No, @Doc_Dt, @Doc_DtAr, @Reftyp_No, @Pym_No, @To_Store, @Unit_No, @Qty, @Exp_Date, @Itm_Pur, @Titm_Pur, @Itm_Sal, @Titm_Sal, @Disc1_Prct, @Disc1_Val, @FcItm_Pur, @FcTitm_Pur, @Batch_No, @Taxp_Extra, @Taxv_Extra, @Sup_No, @Loc_No, @Itm_No)", cn);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Doc_No", Convert.ToInt64(Txt_Doc_No.Text));
cmd.Parameters.AddWithValue("@StoreID", int.Parse(DDL_Store_Number.SelectedValue));
cmd.Parameters.AddWithValue("@Cmp_No", int.Parse(DDL_Com_NO.SelectedValue));
cmd.Parameters.AddWithValue("@Actvty_No", int.Parse(DDL_Actinvity_NO.SelectedValue));
cmd.Parameters.AddWithValue("@Doc_Ty", int.Parse(DDL_Reftyp_No.SelectedValue));
cmd.Parameters.AddWithValue("@Ln_No", int.Parse(Hf_Ln_No.Value));
cmd.Parameters.AddWithValue("@Doc_Dt", Txt_Doc_Dt.Text);
cmd.Parameters.AddWithValue("@Doc_DtAr", Txt_Doc_DtAr.Text);
cmd.Parameters.AddWithValue("@Reftyp_No", int.Parse(DDL_Reftyp_No.SelectedValue));
cmd.Parameters.AddWithValue("@To_Store", int.Parse(DDL_To_Store.SelectedValue));
cmd.Parameters.AddWithValue("@Sup_No", Convert.ToInt64(DDL_Sup_No.SelectedValue));
cmd.Parameters.AddWithValue("@Itm_No", Convert.ToInt64(Txt_Itm_No.Text));
cmd.Parameters.AddWithValue("@Unit_No", int.Parse(DDL_Itm_Unit.SelectedValue));
cmd.Parameters.AddWithValue("@Loc_No", int.Parse(Txt_Loc_No.Text));
cmd.Parameters.AddWithValue("@Qty", Convert.ToDecimal(Txt_Qty.Text));
cmd.Parameters.AddWithValue("@Itm_Pur", Convert.ToDecimal(Txt_Itm_Pur.Text));
cmd.Parameters.AddWithValue("@Exp_Date", Txt_Exp_Date.Text);
cmd.Parameters.AddWithValue("@Batch_No", Txt_Batch_No.Text);
cmd.Parameters.AddWithValue("@Titm_Pur", Convert.ToDecimal(Txt_Titm_Pur.Text));
cmd.Parameters.AddWithValue("@Disc1_Prct", Convert.ToDecimal(Txt_Disc1_Prct.Text));
cmd.Parameters.AddWithValue("@Disc1_Val", Convert.ToDecimal(Txt_Disc1_Val.Text));
cmd.Parameters.AddWithValue("@Itm_Sal", Convert.ToDecimal(Txt_Item_Sal.Text));
cmd.Parameters.AddWithValue("@TItm_Sal", Convert.ToDecimal(Txt_TItem_Sal.Text));
cmd.Parameters.AddWithValue("@FcItm_Pur", Convert.ToDecimal(Txt_FcItm_Pur.Text));
cmd.Parameters.AddWithValue("@FcTitm_Pur", Convert.ToDecimal(Txt_FcTitm_Pur.Text));
cmd.Parameters.AddWithValue("@Taxp_Extra", Convert.ToDecimal(Txt_Taxp_Extra.Text));
cmd.Parameters.AddWithValue("@Taxv_Extra", Convert.ToDecimal(Txt_Taxv_Extra.Text));
cn.Open();
cmd.ExecuteNonQuery();
cn.Close();
GridView1.DataBind();
GVInv_Details.DataBind();
}
protected void LinkButton3_Click(object sender, EventArgs e)
{
New_Ln_No();
SQL_GVInv_Details.InsertParameters["Cmp_No"].DefaultValue = "0";
SQL_GVInv_Details.InsertParameters["Actvty_No"].DefaultValue = "0";
SQL_GVInv_Details.InsertParameters["StoreID"].DefaultValue = "0";
SQL_GVInv_Details.InsertParameters["Doc_Ty"].DefaultValue = "2";
SQL_GVInv_Details.InsertParameters["Doc_No"].DefaultValue = Txt_Doc_No.Text;
SQL_GVInv_Details.InsertParameters["Ln_No"].DefaultValue = Hf_Ln_No.Value;
SQL_GVInv_Details.InsertParameters["Doc_Dt"].DefaultValue = Txt_Doc_Dt.Text;
SQL_GVInv_Details.InsertParameters["Doc_DtAr"].DefaultValue = Txt_Doc_DtAr.Text;
SQL_GVInv_Details.InsertParameters["Reftyp_No"].DefaultValue = DDL_Reftyp_No.SelectedValue;
SQL_GVInv_Details.InsertParameters["Pym_No"].DefaultValue = DDL_Pym_No.SelectedValue;
SQL_GVInv_Details.InsertParameters["To_Store"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("GV_To_Store")).SelectedValue;
SQL_GVInv_Details.InsertParameters["Unit_No"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("GV_Itm_Unit")).SelectedValue;
SQL_GVInv_Details.InsertParameters["Qty"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Qty")).Text;
SQL_GVInv_Details.InsertParameters["Exp_Date"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Exp_Date")).Text;
SQL_GVInv_Details.InsertParameters["Itm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Itm_Pur")).Text;
SQL_GVInv_Details.InsertParameters["Titm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_TItm_Pur")).Text;
SQL_GVInv_Details.InsertParameters["Itm_Sal"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_ItmSal")).Text;
SQL_GVInv_Details.InsertParameters["Titm_Sal"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_TitmSal")).Text;
SQL_GVInv_Details.InsertParameters["Disc1_Prct"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV__Disc1_Prct")).Text;
SQL_GVInv_Details.InsertParameters["Disc1_Val"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Disc1_Val")).Text;
SQL_GVInv_Details.InsertParameters["FcItm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_FcItm_Pur")).Text;
SQL_GVInv_Details.InsertParameters["FcTitm_Pur"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_FcTitm_Pur")).Text;
SQL_GVInv_Details.InsertParameters["Batch_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Batch_No")).Text;
SQL_GVInv_Details.InsertParameters["Taxp_Extra"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Taxp_Extra")).Text;
SQL_GVInv_Details.InsertParameters["Taxv_Extra"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Taxv_Extra")).Text;
SQL_GVInv_Details.InsertParameters["Sup_No"].DefaultValue = ((DropDownList)GVInv_Details.HeaderRow.FindControl("DDL_Sup_No")).SelectedValue;
SQL_GVInv_Details.InsertParameters["Loc_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Loc_No")).Text;
SQL_GVInv_Details.InsertParameters["Itm_No"].DefaultValue = ((TextBox)GVInv_Details.HeaderRow.FindControl("GV_Itm_No")).Text;
SQL_GVInv_Details.Insert();
GVInv_Details.DataBind();
//SqlCommand cmd = new SqlCommand("InvLoddtl_Insert_Pur", cn);
//cmd.CommandType = CommandType.StoredProcedure;
//cmd.Parameters.AddWithValue("@Doc_No", Convert.ToInt64(Txt_Doc_No.Text));
//cmd.Parameters.AddWithValue("@StoreID", int.Parse(DDL_Store_Number.SelectedValue));
//cmd.Parameters.AddWithValue("@Cmp_No", int.Parse(DDL_Com_NO.SelectedValue));
//cmd.Parameters.AddWithValue("@Actvty_No", int.Parse(DDL_Actinvity_NO.SelectedValue));
//cmd.Parameters.AddWithValue("@Doc_Ty", int.Parse(DDL_Reftyp_No.SelectedValue));
//cmd.Parameters.AddWithValue("@Ln_No", int.Parse(Hf_Ln_No.Value));
//cmd.Parameters.AddWithValue("@Doc_Dt", Txt_Doc_Dt.Text);
//cmd.Parameters.AddWithValue("@Doc_DtAr", Txt_Doc_DtAr.Text);
//cmd.Parameters.AddWithValue("@To_Store", int.Parse(DDL_To_Store.SelectedValue));
//cmd.Parameters.AddWithValue("@Sup_No", Convert.ToInt64(DDL_Sup_No.SelectedValue));
//cmd.Parameters.AddWithValue("@Itm_No", Convert.ToInt64(Txt_Itm_No.Text));
//cmd.Parameters.AddWithValue("@Unit_No", int.Parse(DDL_Itm_Unit.SelectedValue));
//cmd.Parameters.AddWithValue("@Loc_No", int.Parse(Txt_Loc_No.Text));
//cmd.Parameters.AddWithValue("@Qty", Convert.ToDecimal(Txt_Qty.Text));
//cmd.Parameters.AddWithValue("@Itm_Pur", Convert.ToDecimal(Txt_Itm_Pur.Text));
//cmd.Parameters.AddWithValue("@Exp_Date", Txt_Exp_Date.Text);
//cmd.Parameters.AddWithValue("@Batch_No", Txt_Batch_No.Text);
//cmd.Parameters.AddWithValue("@Titm_Pur", Convert.ToDecimal(Txt_Titm_Pur.Text));
//cmd.Parameters.AddWithValue("@Disc1_Prct", Convert.ToDecimal(Txt_Disc1_Prct.Text));
//cmd.Parameters.AddWithValue("@Disc1_Val", Convert.ToDecimal(Txt_Disc1_Val.Text));
//cmd.Parameters.AddWithValue("@Itm_SalSubUnt", Convert.ToDecimal(Txt_Item_SalSubUnit.Text));
//cmd.Parameters.AddWithValue("@FcTitm_Sal", Convert.ToDecimal(Txt_FcTitm_Sal.Text));
//cmd.Parameters.AddWithValue("@FcItm_Pur", Convert.ToDecimal(Txt_FcItm_Pur.Text));
//cmd.Parameters.AddWithValue("@FcTitm_Cost", Convert.ToDecimal(Txt_FcTitm_Cost.Text));
//cmd.Parameters.AddWithValue("@Taxp_Extra", Convert.ToDecimal(Txt_Taxp_Extra.Text));
//cmd.Parameters.AddWithValue("@Taxv_Extra", Convert.ToDecimal(Txt_Taxv_Extra.Text));
//cn.Open();
//cmd.ExecuteNonQuery();
//cn.Close();
}
