public void BindDDLVendorBySpare(Label lblrateSAP) { DataSet ds = new DataSet(); SqlParameter[] param = { new SqlParameter("@Type", "SELECT_ALL_VENDOR_ACCORDINGTO_SPARE"), new SqlParameter("@ProductDivision", this._ProductDivision_Id), new SqlParameter("@SpareId", this._SpareId) }; ds = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspSparePurchaseOutside", param); //if (ds.Tables[0].Rows.Count > 0) //{ // ddl.DataSource = ds.Tables[0]; // ddl.DataValueField = "Vendor_Id"; // ddl.DataTextField = "Vendor_Name"; // ddl.DataBind(); // ddl.Items.Insert(0, new ListItem("Select", "0")); //} //else //{ // ddl.Items.Clear(); // ddl.Items.Insert(0, new ListItem("Select", "0")); //} lblrateSAP.Text = Convert.ToString(ds.Tables[1].Rows[0][0]); }
// modified 4 nov bhawesh public void BindComplaintData(GridView gv, String Type) { DataSet dsComplaintData = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@DefId", this.DefId), new SqlParameter("@challan_no", this.challanno), new SqlParameter("@Type", Type) }; //Getting values of Complaint to bind complaint drop downlist using SQL Data Access Layer dsComplaintData = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspChallanPrintScreen", sqlParamS); if (dsComplaintData.Tables[0].Rows.Count > 0) { dsComplaintData.Tables[0].Columns.Add("Sno"); int intCommon = 1; int intCommonCnt = dsComplaintData.Tables[0].Rows.Count; for (int intCnt = 0; intCnt < intCommonCnt; intCnt++) { dsComplaintData.Tables[0].Rows[intCnt]["Sno"] = intCommon; intCommon++; } gv.DataSource = dsComplaintData; gv.DataBind(); } dsComplaintData = null; sqlParamS = null; }
public void BindASC(DropDownList ddlAsc) { DataSet dsASC = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@CGuser", this.CGuser), new SqlParameter("@Type", "GET_ASC_NAME") }; dsASC = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspDestructibleSpareAndServiceActivityList", sqlParamS); //if (dsASC.Tables[0].Rows.Count > 0) //{ // this.ASC = dsASC.Tables[0].Rows[0]["sc_name"].ToString(); //} ddlAsc.DataSource = dsASC; ddlAsc.DataTextField = "SC_Name"; ddlAsc.DataValueField = "sc_sno"; ddlAsc.DataBind(); ddlAsc.Items.Insert(0, new ListItem("Select", "0")); dsASC = null; sqlParamS = null; }
public void Bind_SELECTED_ASC_SPEC_SPARE(int intASCSpareId, string strType) { DataSet dsASC = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@ASC_Spec_Spare_Id", intASCSpareId) }; dsASC = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspASCSpecificSpareMaster", sqlParamG); if (dsASC.Tables[0].Rows.Count > 0) { ASC_Spec_Spare_Id = int.Parse(dsASC.Tables[0].Rows[0]["ASC_Spec_Spare_Id"].ToString()); ASC_Id = Convert.ToInt32(dsASC.Tables[0].Rows[0]["ASC_Id"].ToString()); Loc_Id = Convert.ToInt32(dsASC.Tables[0].Rows[0]["Loc_Id"].ToString()); ProductDivision_Id = Convert.ToInt32(dsASC.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); Spare_Id = Convert.ToInt32(dsASC.Tables[0].Rows[0]["Spare_Id"].ToString()); Lead_Time = dsASC.Tables[0].Rows[0]["Lead_Time"].ToString(); AVGConsumption_Per_Day = dsASC.Tables[0].Rows[0]["AVGConsumption_Per_Day"].ToString(); Safety_Percentage = dsASC.Tables[0].Rows[0]["Safety_Percentage"].ToString(); Reorder_Trigger = dsASC.Tables[0].Rows[0]["Reorder_Trigger"].ToString(); Recommended_Stock = dsASC.Tables[0].Rows[0]["Recommended_Stock"].ToString(); Order_Quantity = dsASC.Tables[0].Rows[0]["Order_Quantity"].ToString(); Min_Order_Quantity = dsASC.Tables[0].Rows[0]["Min_Order_Quantity"].ToString(); ActiveFlag = dsASC.Tables[0].Rows[0]["Active_Flag"].ToString(); } dsASC = null; }
//Bind records of cost centers mapped with product divisions based on search criteria's public void BindGridSAPCostCenterMasterSearch(GridView gvComm, Label lblRowCount) { SqlParameter[] sqlParamSrh = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Active_Flag", this.Active_Flag), new SqlParameter("@SearchCriteria", this.SearchCriteria), new SqlParameter("@ColumnName", this.ColumnName), new SqlParameter("@SortColumnName", this.SortColumnName), new SqlParameter("@SortOrder", this.SortOrder), new SqlParameter("@Type", "SEARCH") }; sqlParamSrh[0].Direction = ParameterDirection.Output; sqlParamSrh[1].Direction = ParameterDirection.ReturnValue; dsCommon = objSqlDAL.ExecuteDataset(CommandType.StoredProcedure, "uspSAPCostCenter", sqlParamSrh); ReturnValue = Convert.ToInt32(sqlParamSrh[1].Value.ToString()); MessageOut = sqlParamSrh[0].Value.ToString(); if (ReturnValue != -1) { gvComm.DataSource = dsCommon; gvComm.DataBind(); lblRowCount.Text = dsCommon.Tables[0].Rows.Count.ToString(); } dsCommon = null; }
public DataSet BindSalesOrderHistoryLog(string strPO_Number) { DataSet ds = new DataSet(); SqlParameter[] sqlParam = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@PO_Number", strPO_Number), new SqlParameter("@Type", "SELECT_SALES_ORDER_ACTIVITY_LOG") }; sqlParam[0].Direction = ParameterDirection.Output; sqlParam[1].Direction = ParameterDirection.ReturnValue; ds = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspSalesOrderReceipts", sqlParam); this.ReturnValue = int.Parse(sqlParam[1].Value.ToString()); if (int.Parse(sqlParam[1].Value.ToString()) == -1) { this.MessageOut = sqlParam[0].Value.ToString(); } sqlParam = null; intCommonCnt = ds.Tables[0].Rows.Count; if (intCommonCnt > 0) { ds.Tables[0].Columns.Add("Sno"); intCommon = 1; for (intCnt = 0; intCnt < intCommonCnt; intCnt++) { ds.Tables[0].Rows[intCnt]["Sno"] = intCommon; intCommon++; } } return(ds); }
public void GetBillNo() { DataSet dsbillno = new DataSet(); SqlParameter[] sqlParam = { new SqlParameter("@Type", "GENERATE_INTERNAL_BILL_NUMBER") }; dsbillno = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspPrintInternalBill", sqlParam); if (dsbillno.Tables[0].Rows.Count > 0) { this.billno = dsbillno.Tables[0].Rows[0]["BillNo"].ToString(); } }
public void BindRegionData(DropDownList ddl) { SqlParameter[] param = { new SqlParameter("@Type", "SELECT_REGION_FILL") }; DataSet ds = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTDefectiveStock", param); ddl.DataSource = ds; ddl.DataTextField = "Region_Desc"; ddl.DataValueField = "Region_SNo"; ddl.DataBind(); ddl.Items.Insert(0, new ListItem("All", "0")); }
public void BindASCCode(DropDownList ddlASCCode) { DataSet dsASCCode = new DataSet(); SqlParameter sqlParam = new SqlParameter("@Type", "SELECT_ASC_FILL"); dsASCCode = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspSpareStockTransferASC", sqlParam); ddlASCCode.DataSource = dsASCCode; ddlASCCode.DataTextField = "ASC_Name"; ddlASCCode.DataValueField = "ASC_Id"; ddlASCCode.DataBind(); ddlASCCode.Items.Insert(0, new ListItem("Select", "Select")); dsASCCode = null; sqlParam = null; }
public void BindProductDivisionData(DropDownList ddl) { SqlParameter[] param = { new SqlParameter("@Type", "SELECT_PRODUCT_DIVISION_FILL"), new SqlParameter("@ASC_Id", this.ASC_Id) }; DataSet ds = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTStockstatementofASC", param); ddl.DataSource = ds; ddl.DataTextField = "Product_Division_Name"; ddl.DataValueField = "ProductDivision_Id"; ddl.DataBind(); ddl.Items.Insert(0, new ListItem("Select", "0")); }
public static string GetAlternateSpare(int intProductDivisionId) { string strResult = string.Empty; Dictionary <string, string> lstdetails = new Dictionary <string, string>(); try { DataSet ds = new DataSet(); SqlParameter[] param = { new SqlParameter("@Type", "BIND_ALL_SPARE_CODE"), new SqlParameter("@ProductLine_Id", intProductDivisionId) }; SIMSSqlDataAccessLayer objsql = new SIMSSqlDataAccessLayer(); ds = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspSpareBOMMaster", param); if (ds != null) { if (ds.Tables.Count > 0) { foreach (DataRow dtrow in ds.Tables[0].Rows) { lstdetails.Add(dtrow["Spare_Id"].ToString(), dtrow["SAP_Desc"].ToString()); } } } JavaScriptSerializer json = new JavaScriptSerializer(); strResult = json.Serialize(lstdetails); return(strResult); } catch (Exception ex) { return(strResult); } }
//#region Functions For Get Invoice Details public DataSet GetInvoiceDetails() { DataSet dsInvoice = new DataSet(); SqlParameter[] sqlParamI = { new SqlParameter("@ProductDivisionSno", ProductDivisionId), new SqlParameter("@AscId", AscId), new SqlParameter("@BranchId", BranchId), new SqlParameter("@RegionId", RegionId), new SqlParameter("@MonthId", MonthId), new SqlParameter("@YearId", YearId), new SqlParameter("@UserName", UserName) }; dsInvoice = objSql.ExecuteDataset(CommandType.StoredProcedure, "GenerateInvoice", sqlParamI); return(dsInvoice); }
public void BindDDLDivision(DropDownList ddlDivision) { DataSet dsDivision = new DataSet(); SqlParameter[] sqlParam = { new SqlParameter("@Type", "SELECT_ALL_UNITCODE_UNITSNO") }; dsDivision = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspStockMovementLog", sqlParam); ddlDivision.DataSource = dsDivision; ddlDivision.DataTextField = dsDivision.Tables[0].Columns[1].ToString(); ddlDivision.DataValueField = dsDivision.Tables[0].Columns[0].ToString(); ddlDivision.DataBind(); ddlDivision.Items.Insert(0, new ListItem("ALL", "0")); dsDivision = null; sqlParam = null; }
public void BindASC() { DataSet dsASC = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@ASC", this.ASC), new SqlParameter("@Type", "GET_ASC_NAME") }; dsASC = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspDestructionOfDefectiveSparesASC", sqlParamS); if (dsASC.Tables[0].Rows.Count > 0) { this.ASC = dsASC.Tables[0].Rows[0]["sc_name"].ToString(); } dsASC = null; sqlParamS = null; }
public void BindSpareBOMOnSpareBOMId(int intSpareBOMID, string strType) { DataSet ds = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@Spare_BOM_Id", intSpareBOMID) }; ds = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspSpareBOMMaster", sqlParamG); if (ds.Tables[0].Rows.Count > 0) { Spare_BOM_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Spare_BOM_Id"].ToString()); ProductDivision_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); ProductLine_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductLine_Id"].ToString()); Product_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Product_Id"].ToString()); Spare_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Spare_Id"].ToString()); QtyPerUnit = Convert.ToInt32(ds.Tables[0].Rows[0]["Spare_BOM_QtyPerUnit"].ToString()); AltSpareCode1 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code1"].ToString()); AltSpareCode2 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code2"].ToString()); AltSpareCode3 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code3"].ToString()); AltSpareCode4 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code4"].ToString()); QtyPerUnitOfAlt1 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code1_QtyPerUnit"].ToString()); QtyPerUnitOfAlt2 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code2_QtyPerUnit"].ToString()); QtyPerUnitOfAlt3 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code3_QtyperUnit"].ToString()); QtyPerUnitOfAlt4 = Convert.ToInt32(ds.Tables[0].Rows[0]["ALT_Spare_Code4_QtyPerUnit"].ToString()); ActiveFlag = ds.Tables[0].Rows[0]["Active_Flag"].ToString(); } ds = null; }
public void BindProductLineOnSNo(int intProductLineSNo, string strType) { DataSet dsProductLine = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@ActivityParameterSNo", intProductLineSNo) }; dsProductLine = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspRateMaster", sqlParamG); if (dsProductLine.Tables[0].Rows.Count > 0) { ActivityParameterSNo = int.Parse(dsProductLine.Tables[0].Rows[0]["ActivityParameter_SNo"].ToString()); UnitSno = int.Parse(dsProductLine.Tables[0].Rows[0]["Unit_Sno"].ToString()); ActivityCode = int.Parse(dsProductLine.Tables[0].Rows[0]["ActivityCode"].ToString()); ParameterCode1 = int.Parse(dsProductLine.Tables[0].Rows[0]["Parameter_Code1"].ToString()); ParameterCode2 = int.Parse(dsProductLine.Tables[0].Rows[0]["Parameter_Code2"].ToString()); ParameterCode3 = int.Parse(dsProductLine.Tables[0].Rows[0]["Parameter_Code3"].ToString()); ParameterCode4 = int.Parse(dsProductLine.Tables[0].Rows[0]["Parameter_Code4"].ToString()); PossibleValue1 = int.Parse(dsProductLine.Tables[0].Rows[0]["ParameterPossible_Id1"].ToString()); PossibleValue2 = int.Parse(dsProductLine.Tables[0].Rows[0]["ParameterPossible_Id2"].ToString()); PossibleValue3 = int.Parse(dsProductLine.Tables[0].Rows[0]["ParameterPossible_Id3"].ToString()); PossibleValue4 = int.Parse(dsProductLine.Tables[0].Rows[0]["ParameterPossible_Id4"].ToString()); UOM = dsProductLine.Tables[0].Rows[0]["UOM"].ToString(); Actual = Convert.ToInt32(dsProductLine.Tables[0].Rows[0]["Actual"].ToString()); Rate = decimal.Parse(dsProductLine.Tables[0].Rows[0]["Rate"].ToString()); SC_SNo = Convert.ToInt32(dsProductLine.Tables[0].Rows[0]["SC_SNo"].ToString()); SC_Name = dsProductLine.Tables[0].Rows[0]["SC_Name"].ToString(); ActiveFlag = dsProductLine.Tables[0].Rows[0]["Active_Flag"].ToString(); } dsProductLine = null; }
public void BindProductDiv() { DataSet dsProductdiv = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@ComplaintNo", this.ComplaintNo), new SqlParameter("@Type", "GET_PRODUCT_DIV") }; dsProductdiv = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspSpareConsumptionAndActivityDetails", sqlParamS); if (dsProductdiv.Tables[0].Rows.Count > 0) { this.ProductDivision = dsProductdiv.Tables[0].Rows[0]["Unit_Desc"].ToString(); } dsProductdiv = null; sqlParamS = null; }
// added 4 july bhawesh public void BindBranches(DropDownList ddlbranch) { DataSet ds = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type","GetBranches") }; ds = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspVendorMaster", sqlParamG); if (ds.Tables[0].Rows.Count > 0) { ddlbranch.DataSource = ds; ddlbranch.DataTextField = "branch_name"; ddlbranch.DataValueField = "branch_sno"; ddlbranch.DataBind(); ddlbranch.Items.Insert(0, "Select"); } ds = null; }
public void BindASC(DropDownList ddlasc) { DataSet dsASC = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@CGuser", this.CGuser), new SqlParameter("@Type", "GET_ASC_NAME") }; dsASC = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspClaimApprovalWarrantyComplaints", sqlParamS); ddlasc.DataValueField = "sc_sno"; ddlasc.DataTextField = "SC_Name"; ddlasc.DataSource = dsASC; ddlasc.DataBind(); ddlasc.Items.Insert(0, new ListItem("Select", "0")); dsASC = null; sqlParamS = null; }
public void BindProductDivision(DropDownList ddlproductdivision) { DataSet dsProductDiv = new DataSet(); SqlParameter[] sqlParamS = { new SqlParameter("@ASC", this.Asc), new SqlParameter("@Type", "SELECT_PRODUCT_DIVISION") }; //Getting values of Complaint to bind complaint drop downlist using SQL Data Access Layer dsProductDiv = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspStockView", sqlParamS); ddlproductdivision.DataSource = dsProductDiv; ddlproductdivision.DataTextField = "Unit_Desc"; ddlproductdivision.DataValueField = "Unit_Sno"; ddlproductdivision.DataBind(); ddlproductdivision.Items.Insert(0, new ListItem("Select", "0")); dsProductDiv = null; sqlParamS = null; }
public void BindASC(DropDownList ddlASC) { DataSet dsASC = new DataSet(); SqlParameter[] sqlParamS = { //new SqlParameter("@ASC",this.ASC), new SqlParameter("@CGuser", this.CGuser), new SqlParameter("@Type", "GET_ASC_NAME") }; dsASC = objsql.ExecuteDataset(CommandType.StoredProcedure, "uspDefectiveSpareChallanConfirmation", sqlParamS); ddlASC.DataSource = dsASC; ddlASC.DataTextField = "sc_name"; ddlASC.DataValueField = "SC_Sno"; ddlASC.DataBind(); ddlASC.Items.Insert(0, new ListItem("Select", "0")); dsASC = null; sqlParamS = null; }
protected void btnSearch_Click(object sender, EventArgs e) { sqlParamSrh[0].Value = TxtIBN.Text.Trim(); DataSet ds = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "SearchDetailByIBN", sqlParamSrh); lblCount.Text = ds.Tables[0].Rows.Count.ToString(); gvMIS.DataSource = ds; gvMIS.DataBind(); }
public DataSet BindData(GridView grv) { SqlParameter[] sqlParamSrh = { //new SqlParameter("@MessageOut",SqlDbType.VarChar,200), //new SqlParameter("@Type","SELECT"), //new SqlParameter("@Region_Sno",this.Region_Sno), //new SqlParameter("@Branch_Sno",this.Branch_SNo), //new SqlParameter("@ProductDivision_Id",this.ProductDivision_Id), //new SqlParameter("@ASC_Id",this.ASC_Id) new SqlParameter("@Region_Sno", this.Region_Sno), new SqlParameter("@Branch_Sno", this.Branch_SNo), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Type", "SELECT"), new SqlParameter("@ddlDefectCategory", this.Defect_Category_SNo), new SqlParameter("@ddlDefectCode", this.Defect_Code), new SqlParameter("@ProductLine_Sno", this.ProductLine_Sno), new SqlParameter("@FromDate", this.Fromdate), new SqlParameter("@ToDate", this.ToDate), new SqlParameter("@MessageOut", SqlDbType.VarChar, 200) }; sqlParamSrh[10].Direction = ParameterDirection.Output; // 10 apr 12 , merge with type : SELECT_NW (complaint cancelled at Init. ) // DataSet ds = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTPendingClaimApproval_New", sqlParamSrh); sqlParamSrh[4].Value = "SELECT_NW"; dstData = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTPendingClaimApproval_New", sqlParamSrh); dstData.Merge(ds); if (dstData.Tables[0].Rows.Count > 0) { dstData.Tables[0].Columns.Add("Total"); dstData.Tables[0].Columns.Add("Sno"); int intCnt, intCommon = 1; int intCommonCnt = dstData.Tables[0].Rows.Count; for (intCnt = 0; intCnt < intCommonCnt; intCnt++) { dstData.Tables[0].Rows[intCnt]["Sno"] = intCommon; dstData.Tables[0].Rows[intCnt]["Total"] = intCommonCnt; intCommon++; } } grv.DataSource = dstData; grv.DataBind(); // dstData = objCommonClass.BindDataGrid(grv, "uspRPTPendingClaimApproval_New", true, sqlParamSrh, true); return(dstData); }
public DataSet BindGridSalesOrder(GridView gvComm, Label lblRowCount) { SqlParameter[] sqlParamSrh = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Active_Flag", "1"), //FOR SOFT DELETE OR FILTERING new SqlParameter("@Type", this.ActionType), }; sqlParamSrh[0].Direction = ParameterDirection.Output; sqlParamSrh[1].Direction = ParameterDirection.ReturnValue; dsCommon = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspDestructionDefectiveSpares", sqlParamSrh); ReturnValue = Convert.ToInt32(sqlParamSrh[1].Value.ToString()); MessageOut = sqlParamSrh[0].Value.ToString(); if (ReturnValue != -1) { lblRowCount.Text = dsCommon.Tables[0].Rows.Count.ToString(); objCommonClass.SortGridData(gvComm, dsCommon, this.SortColumnName, this.SortOrderBy); } return(dsCommon); }
public void BindActivityParameter(int intId, string strType) { DataSet ds = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@ActivityParameterMapping_Id", intId) }; ds = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspActivityParameterMapping", sqlParamG); if (ds.Tables[0].Rows.Count > 0) { ActivityParameterMapping_Id = int.Parse(ds.Tables[0].Rows[0]["ActivityParameterMapping_Id"].ToString()); ProductDivision_Id = int.Parse(ds.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); Activity_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Activity_Id"].ToString()); Parameter_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Parameter_Id"].ToString()); Active_Flag = ds.Tables[0].Rows[0]["Active_Flag"].ToString(); } ds = null; }
public void GetSapareMappingDetails(int intSpareMappingId, string strType) { DataSet ds = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@SpareMapping_Id", intSpareMappingId) }; ds = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspVendorSpareMapping", sqlParamG); if (ds.Tables[0].Rows.Count > 0) { SpareMapping_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["SpareMapping_Id"].ToString()); Vendor_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Vendor_Id"].ToString()); ProductDivision_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); Spare_BOM_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Spare_BOM_Id"].ToString()); ActiveFlag = ds.Tables[0].Rows[0]["Active_Flag"].ToString(); } ds = null; }
public void BindParameterPossibleValue(int intId, string strType) { DataSet ds = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@ParameterPossible_Id", intId) }; ds = objSqlDAL.ExecuteDataset(CommandType.StoredProcedure, "uspParameterPossibleValue", sqlParamG); if (ds.Tables[0].Rows.Count > 0) { ParameterPossible_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["ParameterPossible_Id"].ToString()); ProductDivision_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["ProductDivision_Id"].ToString()); Parameter_Id = Convert.ToInt32(ds.Tables[0].Rows[0]["Parameter_Id"].ToString()); Possibl_Value = ds.Tables[0].Rows[0]["Possibl_Value"].ToString(); Active_Flag = ds.Tables[0].Rows[0]["Active_Flag"].ToString(); } ds = null; }
public void BindProductOnSNo(int intProductSNo, string strType) { try { DataSet dsProduct = new DataSet(); SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@Product_SNo", intProductSNo) }; dsProduct = objSql.ExecuteDataset(CommandType.StoredProcedure, "uspFGIntermediate", sqlParamG); if (dsProduct.Tables[0].Rows.Count > 0) { ProductSNo = int.Parse(dsProduct.Tables[0].Rows[0]["Intermediate_FG_Id"].ToString()); ProductCode = dsProduct.Tables[0].Rows[0]["Product_Code"].ToString(); //ProductDescFGIntmd = dsProduct.Tables[0].Rows[0]["Product_Desc"].ToString(); //ProductMappingFlag = dsProduct.Tables[0].Rows[0]["Product_Mapped"].ToString(); } dsProduct = null; } catch (Exception ex) { throw ex; } }
public DataSet BindData(GridView grv) { SqlParameter[] sqlParamSrh = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Type", "SELECT"), new SqlParameter("@Region_Sno", this.Region_Sno), new SqlParameter("@Branch_Sno", this.Branch_SNo), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@From_Date", this.From_Date), new SqlParameter("@To_Date", this.To_Date), new SqlParameter("@ASC_Id", this.ASC_Id) }; sqlParamSrh[0].Direction = ParameterDirection.Output; dstData = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspRPTSpareConsumptionSummary", sqlParamSrh); if (dstData.Tables[0].Rows.Count > 0) { int intCommon = 1; for (int intCnt = 0; intCnt < dstData.Tables[0].Rows.Count; intCnt++) { dstData.Tables[0].Rows[intCnt][0] = intCommon; intCommon++; } } grv.DataSource = dstData; grv.DataBind(); return(dstData); }
/// <summary> /// Return Dataset for binding grid /// </summary> /// <returns></returns> public DataSet GetGridData() { DataSet ds = new DataSet(); TotalPage = 0; SqlParameter[] sqlParamI = { new SqlParameter("@UserName", this.EmpCode), new SqlParameter("@ActiveStatus", this.ActiveStatus), new SqlParameter("@RegionSno", this.RegionSno), new SqlParameter("@ProductDivisionId", this.ProductDivisionSno), new SqlParameter("@BranchSno", this.BranchSno), new SqlParameter("@AscId", this.AscId), new SqlParameter("@CunstumptionStatus", this.ConsumptionStatus), new SqlParameter("@StickerCode", this.StickerCode), new SqlParameter("@Type", this.Type), new SqlParameter("@AllocationStatus", this.AllocationStatus), new SqlParameter("@SortingOrder", this.SortingOrder), new SqlParameter("@PageIndex", this.PageIndex), new SqlParameter("@Role", this.Role), new SqlParameter("@PageSize", this.PageSize), new SqlParameter("@AllocationType", this.AllocationType) }; ds = objSqlDataAccessLayer.ExecuteDataset(CommandType.StoredProcedure, "uspGetStickerDetails", sqlParamI); if (this.Type.Equals("SELECT", StringComparison.InvariantCultureIgnoreCase)) { if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0].Rows.Count > 0) { TotalPage = Convert.ToInt32(ds.Tables[0].Rows[0]["TotalCount"]); } } } } sqlParamI = null; return(ds); }