public DataSet dal_GDNDetail(bel_GDN obj_bel_GDN)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_GDNSearch");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@GDNID", obj_bel_GDN._GDNID);
sqlcmd.Parameters.AddWithValue("@GDNDetailID", obj_bel_GDN._GDNDetailID);
sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"]));
sqlcmd.Parameters.AddWithValue("@GDNNo", obj_bel_GDN._GDNNo);
sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"]));
sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_GDN._ProductID);
sqlcmd.Parameters.AddWithValue("@PartyID", obj_bel_GDN._PartyID);
sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_GDN._JOBID);
sqlcmd.Parameters.AddWithValue("@BillFromDate", obj_bel_GDN._BillFromDate);
sqlcmd.Parameters.AddWithValue("@BillToDate", obj_bel_GDN._BillToDate);
sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_GDN._iMode);
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_GDN._ScreenName);
sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_GDN._ProductCode);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@OrderID", obj_bel_GDN._OrderID);
sqlcmd.Parameters.AddWithValue("@Type", obj_bel_GDN._Type);
sqlcmd.Parameters.AddWithValue("@ToWarehouseID", obj_bel_GDN._WareHouseID);
sqlcmd.Parameters.AddWithValue("@FromWarehouseID", obj_bel_GDN._FromWareHouseID);
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public DataSet dal_AutoGen(bel_GDN obj_bel_GDN)
{
DataSet ds = new DataSet();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_AutoGenTransaction");
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_GDN._ScreenName);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_GDN._BillFromDate);
sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_GDN._BillToDate);
sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"]));
ds = DataFunctions.GetDataSet(sqlcmd);
}
catch (Exception ex)
{
}
return ds;
}
public int dal_GDNInsert(bel_GDN obj_bel_GDN, DataTable dt)
{
int value;
int Result = 0;
string connectionString = ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString;
SqlConnection connection = new SqlConnection(connectionString);
SqlTransaction trn;
connection.Open();
trn = connection.BeginTransaction();
try
{
SqlCommand sqlcmd = new SqlCommand("spu_GDNHeader", connection, trn);
sqlcmd.CommandTimeout = 0;
sqlcmd.CommandType = CommandType.StoredProcedure;
sqlcmd.Parameters.Clear();
if (obj_bel_GDN._GDNID != 0)
{
sqlcmd.Parameters.AddWithValue("@iMode", "Update");
sqlcmd.Parameters.AddWithValue("@GDNID", obj_bel_GDN._GDNID);
}
else
{
sqlcmd.Parameters.AddWithValue("@iMode", "Insert");
sqlcmd.Parameters.AddWithValue("@GDNID", 0);
}
sqlcmd.Parameters.AddWithValue("@GDNNo", obj_bel_GDN._GDNNo);
sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"]));
sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"]));
sqlcmd.Parameters.AddWithValue("@GDNDate", obj_bel_GDN._GDNDate);
sqlcmd.Parameters.AddWithValue("@PartyID", obj_bel_GDN._PartyID);
sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_GDN._JOBID);
sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_GDN._CreatedOn);
sqlcmd.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"]));
sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_GDN._ModifiedOn);
sqlcmd.Parameters.AddWithValue("@Status", obj_bel_GDN._Status);
sqlcmd.Parameters.AddWithValue("@Through", obj_bel_GDN._Through);
sqlcmd.Parameters.AddWithValue("@Remarks", obj_bel_GDN._Remarks);
sqlcmd.Parameters.AddWithValue("@OrderID", obj_bel_GDN._OrderID);
sqlcmd.Parameters.AddWithValue("@WareHouseID", obj_bel_GDN._WareHouseID);
sqlcmd.Parameters.AddWithValue("@FromWareHouseID", obj_bel_GDN._FromWareHouseID);
sqlcmd.Parameters.AddWithValue("@Type", obj_bel_GDN._Type);
sqlcmd.Parameters.AddWithValue("@TotalQty", obj_bel_GDN._TotalQty);
sqlcmd.Parameters.AddWithValue("@TotalAmount", obj_bel_GDN._TotalAmount);
sqlcmd.Parameters.AddWithValue("@ToBranchID", obj_bel_GDN._ToBranchID);
sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"]));
sqlcmd.Parameters["@GDNID"].Direction = ParameterDirection.InputOutput;
value = sqlcmd.ExecuteNonQuery();
val = (int)sqlcmd.Parameters["@GDNID"].Value;
HttpContext.Current.Session["HeaderID"] = Convert.ToString(val);
SqlCommand sqlcmd2 = new SqlCommand("spu_GDNDetail", connection, trn);
sqlcmd2.CommandTimeout = 0;
sqlcmd2.CommandType = CommandType.StoredProcedure;
for (int i = 0; i <= dt.Rows.Count - 1; i++)
{
sqlcmd2.Parameters.Clear();
if (Convert.ToString(dt.Rows[i]["GDNDetailID"]) == "0")
{
sqlcmd2.Parameters.AddWithValue("@iMode", "Insert");
sqlcmd2.Parameters.AddWithValue("@GDNID", Convert.ToInt32(val));
sqlcmd2.Parameters.AddWithValue("@GDNDetailID", 0);
}
else
{
sqlcmd2.Parameters.AddWithValue("@iMode", "Update");
sqlcmd2.Parameters.AddWithValue("@GDNID", Convert.ToInt32(val));
sqlcmd2.Parameters.AddWithValue("@GDNDetailID", dt.Rows[i]["GDNDetailID"]);
}
sqlcmd2.Parameters.AddWithValue("@ProductGroupID", Convert.ToInt32(dt.Rows[i]["ProductGroupID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@ProductID", Convert.ToInt32(dt.Rows[i]["ProductID"].ToString()));
if (Convert.ToString(dt.Rows[i]["Qty"]) != string.Empty)
{
sqlcmd2.Parameters.AddWithValue("@Qty", Convert.ToDecimal(dt.Rows[i]["Qty"].ToString()));
}
else
{
sqlcmd2.Parameters.AddWithValue("@Qty", 0);
}
if (Convert.ToString(dt.Rows[i]["Rate"].ToString()) != string.Empty)
{
sqlcmd2.Parameters.AddWithValue("@Rate", Convert.ToDecimal(dt.Rows[i]["Rate"].ToString()));
}
else
{
sqlcmd2.Parameters.AddWithValue("@Rate", 0);
}
if (Convert.ToString(dt.Rows[i]["Amount"].ToString()) != string.Empty)
{
sqlcmd2.Parameters.AddWithValue("@Amount", Convert.ToDecimal(dt.Rows[i]["Amount"].ToString()));
}
else
{
sqlcmd2.Parameters.AddWithValue("@Amount", 0);
}
sqlcmd2.Parameters.AddWithValue("@DesignID", Convert.ToInt32(dt.Rows[i]["DesignID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@SizeID", Convert.ToInt32(dt.Rows[i]["SizeID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@ColorID", Convert.ToInt32(dt.Rows[i]["ColorID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@CategoryID", Convert.ToInt32(dt.Rows[i]["CategoryID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@QualityID", Convert.ToInt32(dt.Rows[i]["QualityID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@UOMID", Convert.ToInt32(dt.Rows[i]["UOMID"].ToString()));
sqlcmd2.Parameters.AddWithValue("@Weight", Convert.ToDecimal(dt.Rows[i]["Weight"].ToString()));
sqlcmd2.Parameters.AddWithValue("@Description", Convert.ToString(dt.Rows[i]["Description"]));
Result = sqlcmd2.ExecuteNonQuery();
}
trn.Commit();
//Dsstockin = DataFunctions.GetDataSet(sqlcmd);
}
catch (SqlException ex)
{
trn.Rollback();
}
connection.Close();
return Result;
}
void funGetAvailableQty(bel_GDN obj_bel_Gdn)
{
try
{
decimal AviQty = 0;
decimal Qty = 0;
decimal TotalAviQty = 0;
using (DataSet ds = obj_dal_Gdn.dal_GDNDetail(obj_bel_Gdn))
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
AviQty = Convert.ToDecimal(ds.Tables[0].Rows[0]["AviQty"].ToString());
}
if (ds.Tables[1].Rows.Count > 0)
{
Qty = Convert.ToDecimal(ds.Tables[1].Rows[0]["Qty"].ToString());
}
TotalAviQty = AviQty + Qty;
HAvilableQty.Value = Convert.ToString(TotalAviQty);
}
}
}
catch (Exception ex)
{
obj_Common.LogFile(ex.Message, "GDN:funGetAvailableQty", Convert.ToInt32(ex.StackTrace.Substring(ex.StackTrace.LastIndexOf(":line") + 5)), this.Page.ToString());
}
}
//selected item will sow the corresponding text box
void functionfetcdata(bel_GDN obj_bel_Gdn)
{
try
{
obj_bel_Gdn._iMode = "Fetch";
using (DataSet ds = obj_dal_Gdn.dal_GDNDetail(obj_bel_Gdn))
{
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
if (ds.Tables[0].Rows[0]["GDNID"] != null)
{
hfldid.Value = ds.Tables[0].Rows[0]["GDNID"].ToString();
}
if (ds.Tables[0].Rows[0]["GDNNo"] != null)
{
txtGDNNo.Text = ds.Tables[0].Rows[0]["GDNNo"].ToString();
}
if (ds.Tables[0].Rows[0]["GDNDate"] != null)
{
DateTime date = System.DateTime.Now;
date = Convert.ToDateTime(ds.Tables[0].Rows[0]["GDNDate"]);
txtGDNdate.Text = date.ToString("dd-MMM-yyyy");
}
if (ds.Tables[0].Rows[0]["Type"] != null)
{
Session["GDNType"] = ds.Tables[0].Rows[0]["Type"].ToString();
funGDNTYPE();
}
if (ds.Tables[0].Rows[0]["PartyID"] != null)
{
DropParty.SelectedValue = ds.Tables[0].Rows[0]["PartyID"].ToString();
}
if (ds.Tables[0].Rows[0]["JOBID"] != null)
{
DropJobNo.SelectedValue = ds.Tables[0].Rows[0]["JOBID"].ToString();
}
if (ds.Tables[0].Rows[0]["OrderID"] != null)
{
DropOrder.SelectedValue = ds.Tables[0].Rows[0]["OrderID"].ToString();
}
if (ds.Tables[0].Rows[0]["Status"] != null)
{
// rblPaymenttype.SelectedValue = ds.Tables[0].Rows[0]["Status"].ToString();
}
if (ds.Tables[0].Rows[0]["FromWareHouseID"] != null)
{
DropFromWarehouse.SelectedValue = ds.Tables[0].Rows[0]["FromWareHouseID"].ToString();
}
if (ds.Tables[0].Rows[0]["WareHouseID"] != null)
{
DropWareHouse.SelectedValue = ds.Tables[0].Rows[0]["WareHouseID"].ToString();
}
if (ds.Tables[0].Rows[0]["Through"] != null)
{
txtThrough.Text = ds.Tables[0].Rows[0]["Through"].ToString();
}
if (ds.Tables[0].Rows[0]["Remarks"] != null)
{
txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString();
}
if (ds.Tables[0].Rows[0]["ToBranchID"] != null)
{
HTOBranchID.Value = ds.Tables[0].Rows[0]["ToBranchID"].ToString();
}
}
if (ds.Tables[1].Rows.Count > 0)
{
Session["GDNItem_dt"] = ds.Tables[1];
gridGDN.DataSource = Session["GDNItem_dt"] as DataTable;
gridGDN.DataBind();
if (HGDNTYPE.Value == "S")
{
funSupplierSelectedPOPUP();
}
else if (HGDNTYPE.Value == "P")
{
funProcessorSelectedPOPUP();
}
else if (HGDNTYPE.Value == "G")
{
functionGeneralbindReceived();
}
else if (HGDNTYPE.Value == "D")
{
funDepartmentBind();
}
}
}
}
}
catch (Exception ex)
{
obj_Common.LogFile(ex.Message, "GDN:functionfetcdata", Convert.ToInt32(ex.StackTrace.Substring(ex.StackTrace.LastIndexOf(":line") + 5)), this.Page.ToString());
}
}
