public DataSet dal_GTNDetail(bel_GTN obj_bel_GTN) { DataSet ds = new DataSet(); try { SqlCommand sqlcmd = new SqlCommand("spu_GTNSearch"); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); sqlcmd.Parameters.AddWithValue("@GTNID", obj_bel_GTN._GTNID); sqlcmd.Parameters.AddWithValue("@GTNDetailID", obj_bel_GTN._GTNDetailID); sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd.Parameters.AddWithValue("@ProductID", obj_bel_GTN._ProductID); sqlcmd.Parameters.AddWithValue("@ProductCode", obj_bel_GTN._ProductCode); sqlcmd.Parameters.AddWithValue("@JOBID", obj_bel_GTN._JOBID); sqlcmd.Parameters.AddWithValue("@ScreenName", obj_bel_GTN._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@iMode", obj_bel_GTN._iMode); sqlcmd.Parameters.AddWithValue("@CategoryID", obj_bel_GTN._CategoryID); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
public DataSet dal_AutoGen(bel_GTN obj_bel_GTN) { 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_GTN._ScreenName); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters.AddWithValue("@FromDate", obj_bel_GTN._BillFromDate); sqlcmd.Parameters.AddWithValue("@ToDate", obj_bel_GTN._BillToDate); sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"])); ds = DataFunctions.GetDataSet(sqlcmd); } catch (Exception ex) { } return ds; }
void funGetAvailableQty(bel_GTN obj_bel_GTN) { try { decimal AviQty = 0; decimal Qty = 0; decimal TotalAviQty = 0; obj_bel_GTN._iMode = "GetAvailableQty"; using (DataSet ds = obj_dal_GTN.dal_GTNDetail(obj_bel_GTN)) { 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, "GTN: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_GTN obj_bel_GTN) { try { obj_bel_GTN._iMode = "Fetch"; using (DataSet ds = obj_dal_GTN.dal_GTNDetail(obj_bel_GTN)) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["GTNID"] != null) { hfldid.Value = ds.Tables[0].Rows[0]["GTNID"].ToString(); } if (ds.Tables[0].Rows[0]["GTNNo"] != null) { txtGTNNo.Text = ds.Tables[0].Rows[0]["GTNNo"].ToString(); } if (ds.Tables[0].Rows[0]["GTNDate"] != null) { DateTime date = System.DateTime.Now; date = Convert.ToDateTime(ds.Tables[0].Rows[0]["GTNDate"]); txtGTNDate.Text = date.ToString("dd-MMM-yyyy"); // .Text = ds.Tables[0].Rows[0]["GTNDate"].ToString(); } if (ds.Tables[0].Rows[0]["FromJOBID"] != null) { DropFromJobNo.SelectedValue = ds.Tables[0].Rows[0]["FromJOBID"].ToString(); } if (ds.Tables[0].Rows[0]["ToJOBID"] != null) { DropToJobNo.SelectedValue = ds.Tables[0].Rows[0]["ToJOBID"].ToString(); } if (ds.Tables[0].Rows[0]["Status"] != null) { // rblstate.SelectedValue = ds.Tables[0].Rows[0]["Status"].ToString(); } if (ds.Tables[0].Rows[0]["Remarks"] != null) { txtRemarks.Text = ds.Tables[0].Rows[0]["Remarks"].ToString(); } if (ds.Tables[0].Rows[0]["FromWareHouseID"] != null) { DropFromwarehouse.SelectedValue = ds.Tables[0].Rows[0]["FromWareHouseID"].ToString(); } if (ds.Tables[0].Rows[0]["ToWareHouseID"] != null) { DropTowarehouse.SelectedValue = ds.Tables[0].Rows[0]["ToWareHouseID"].ToString(); } } if (ds.Tables[1].Rows.Count > 0) { Session["GTNItem_dt"] = ds.Tables[1]; gridGTN.DataSource = Session["GTNItem_dt"] as DataTable; gridGTN.DataBind(); } } } } catch (Exception ex) { obj_Common.LogFile(ex.Message, "GTN:functionfetcdata", Convert.ToInt32(ex.StackTrace.Substring(ex.StackTrace.LastIndexOf(":line") + 5)), this.Page.ToString()); } }
public int dal_GTNInsert(bel_GTN obj_bel_GTN, 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_GTNHeader", connection, trn); sqlcmd.CommandTimeout = 0; sqlcmd.CommandType = CommandType.StoredProcedure; sqlcmd.Parameters.Clear(); if (obj_bel_GTN._GTNID != 0) { sqlcmd.Parameters.AddWithValue("@iMode", "Update"); sqlcmd.Parameters.AddWithValue("@GTNID", obj_bel_GTN._GTNID); } else { sqlcmd.Parameters.AddWithValue("@iMode", "Insert"); sqlcmd.Parameters.AddWithValue("@GTNID", 0); } sqlcmd.Parameters.AddWithValue("@GTNNo", obj_bel_GTN._GTNNo); sqlcmd.Parameters.AddWithValue("@BranchID", Convert.ToInt32(HttpContext.Current.Session["BranchID"])); sqlcmd.Parameters.AddWithValue("@Year", Convert.ToInt32(HttpContext.Current.Session["FinancialYear"])); sqlcmd.Parameters.AddWithValue("@GTNDate", obj_bel_GTN._GTNDate); // sqlcmd.Parameters.AddWithValue("@FromJOBID", obj_bel_GTN._FromJOBID); sqlcmd.Parameters.AddWithValue("@ToJOBID", obj_bel_GTN._ToJOBID); sqlcmd.Parameters.AddWithValue("@CreatedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd.Parameters.AddWithValue("@CreatedOn", obj_bel_GTN._CreatedOn); sqlcmd.Parameters.AddWithValue("@ModifiedBy", Convert.ToInt32(HttpContext.Current.Session["UserID"])); sqlcmd.Parameters.AddWithValue("@ModifiedOn", obj_bel_GTN._ModifiedOn); sqlcmd.Parameters.AddWithValue("@Status", obj_bel_GTN._Status); sqlcmd.Parameters.AddWithValue("@Remarks", obj_bel_GTN._Remarks); sqlcmd.Parameters.AddWithValue("@ToWareHouseID", obj_bel_GTN._ToWareHouseID); sqlcmd.Parameters.AddWithValue("@FromWareHouseID", obj_bel_GTN._FromWareHouseID); sqlcmd.Parameters.AddWithValue("@TotalQty", obj_bel_GTN._TotalQty); sqlcmd.Parameters.AddWithValue("@TotalAmount", obj_bel_GTN._TotalAmount); sqlcmd.Parameters.AddWithValue("@CompanyID", Convert.ToInt32(HttpContext.Current.Session["CompanyID"])); sqlcmd.Parameters["@GTNID"].Direction = ParameterDirection.InputOutput; value = sqlcmd.ExecuteNonQuery(); val = (int)sqlcmd.Parameters["@GTNID"].Value; HttpContext.Current.Session["HeaderID"] = Convert.ToString(val); SqlCommand sqlcmd2 = new SqlCommand("spu_GTNDetail", 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]["GTNDetailID"]) == "0") { sqlcmd2.Parameters.AddWithValue("@iMode", "Insert"); sqlcmd2.Parameters.AddWithValue("@GTNID", Convert.ToInt32(val)); sqlcmd2.Parameters.AddWithValue("@GTNDetailID", 0); } else { sqlcmd2.Parameters.AddWithValue("@iMode", "Update"); sqlcmd2.Parameters.AddWithValue("@GTNID", Convert.ToInt32(val)); sqlcmd2.Parameters.AddWithValue("@GTNDetailID", dt.Rows[i]["GTNDetailID"]); } 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())); Result = sqlcmd2.ExecuteNonQuery(); } trn.Commit(); //Dsstockin = DataFunctions.GetDataSet(sqlcmd); } catch (SqlException ex) { trn.Rollback(); } connection.Close(); return Result; }