public string InsertPartDelivery() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", "INSERT_PART_DELIVERY_DATE"), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Ordered_Transaction_No", this.Ordered_Transaction_No), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@Part_Delivery_Date", this.Part_Delivery_Date), new SqlParameter("@Quantity", this.Quantity) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspDeliverySchedule", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveProposedQty(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Generated_Transaction_No", SqlDbType.VarChar, 200), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@Current_Stock", this.Current_Stock), new SqlParameter("@Proposed_Qty", this.Proposed_Qty), new SqlParameter("@Rate", this.Rate), new SqlParameter("@Discount", this.Discount), new SqlParameter("@Value", this.Value), new SqlParameter("@Complaint_RefNo", this.Complaint_RefNo), new SqlParameter("@Complaint_No", this.Complaint_no), new SqlParameter("@SplitComplaint_RefNo", this.Complaint_SplitNo) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; sqlParamI[2].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareRequirementIndent", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); Generated_Transaction_No = sqlParamI[2].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@Spare_BOM_Id", this.Spare_BOM_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@ProductLine_Id", this.ProductLine_Id), new SqlParameter("@Product_Id", this.Product_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@QtyPerUnit", this.QtyPerUnit), new SqlParameter("@AltSpareCode1", this.AltSpareCode1), new SqlParameter("@AltSpareCode2", this.AltSpareCode2), new SqlParameter("@AltSpareCode3", this.AltSpareCode3), new SqlParameter("@AltSpareCode4", this.AltSpareCode4), new SqlParameter("@QtyPerUnitOfAlt1", this.QtyPerUnitOfAlt1), new SqlParameter("@QtyPerUnitOfAlt2", this.QtyPerUnitOfAlt2), new SqlParameter("@QtyPerUnitOfAlt3", this.QtyPerUnitOfAlt3), new SqlParameter("@QtyPerUnitOfAlt4", this.QtyPerUnitOfAlt4), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareBOMMaster", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@Document_No", this.AutoGeneratedNumber), new SqlParameter("@Asc_Code", this.ASC_Id), new SqlParameter("@ProductDivision", this.ProductDivision_Id), // new SqlParameter("@Vendor_Id",this.VendorId), new SqlParameter("@Vendor", this.Vendor), new SqlParameter("@SpareId", this.SpareId), new SqlParameter("@Quantity", this.Quantity), new SqlParameter("@RateSAP", this.RateSAP), new SqlParameter("@RatePurchased", this.RatePurchased), new SqlParameter("@Amount", this.Amount), new SqlParameter("@Bill_No", this.BillNo), new SqlParameter("@Bill_Date", this.BillDate), new SqlParameter("@Comments", this.Comments), new SqlParameter("@EmpCode", Membership.GetUser().UserName.ToString()) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSparePurchaseOutside", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { try { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Product_Code", this.ProductCode), new SqlParameter("@Product_Desc", this.ProductDesc), new SqlParameter("@Unit_Sno", this.Unit_Sno), new SqlParameter("@ProductLine_SNo", this.ProductLine_SNo), new SqlParameter("@Rating_Status", "C"), //this.Rating_Status), new SqlParameter("@ProductGroup_SNo", this.ProductGroup_SNo), new SqlParameter("@Active_Flag", 1), //int.Parse(this.ActiveFlag)), new SqlParameter("@Product_SNo", this.ProductSNo) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspFGIntermediate", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); } catch (Exception ex) { throw ex; } }
public string AllocateStickers() { SqlParameter[] sqlParamI = { new SqlParameter("@Message", SqlDbType.VarChar, 1000), new SqlParameter("@XmlData", SqlDbType.Xml), new SqlParameter("@BranchSno", this.BranchSno), new SqlParameter("RegionSno", this.RegionSno), new SqlParameter("@Type", "ALLOCATESTICKER") }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Value = this.xmlAtribute; objSqlDataAccessLayer.ExecuteNonQuery(CommandType.StoredProcedure, "uspGetStickerDetails", sqlParamI); return(sqlParamI[0].Value.ToString()); }
public void BindAscName() { SqlParameter[] sqlParamI = { new SqlParameter("@ASCName", SqlDbType.VarChar, 200), new SqlParameter("@ASC", this.ASC), new SqlParameter("@Type", "GET_ASC_NAME") }; sqlParamI[0].Direction = ParameterDirection.Output; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspChallanPrintScreen", sqlParamI); ASCName = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@From_Loc_Id", this.From_Loc_Id), new SqlParameter("@To_Loc_Id", this.To_Loc_Id), new SqlParameter("@Transfered_Qty", this.Transfered_Qty) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareStockTransferASC", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(double strRate, int intActivityParameter_SNo, int intProductDivision_Id, int intServiceContractor_Id) { string strMsg = ""; try { DataSet ds = new DataSet(); SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", "INSERT_RATE_MASTER_DATA"), new SqlParameter("@Rate", strRate), new SqlParameter("@Actual", this.Actual), new SqlParameter("@ActivityParameter_SNo", intActivityParameter_SNo), new SqlParameter("@ProductDivision_Id", intProductDivision_Id), new SqlParameter("@ServiceContractor_Id", intServiceContractor_Id), }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspRateMasterForASC", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; } catch (Exception ex) { strMsg = "Records not Saved!"; } return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@Stock_Status_Code", this.StockStatusLookUpCode), new SqlParameter("@Stock_Status_Desc", this.StockStatusLookUpDesc), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Stock_SNo", this.intStockStatusSno), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Stock_Status_lookUp_Id", this.intStockStatusSno) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSIMSSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspStockStatusLookUp", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public void SaveStockUpdateMaster() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@StorageLocId", this.StorageLocId), new SqlParameter("@ASCCode", this.ASCCode), new SqlParameter("@Division", this.Division), new SqlParameter("@SpareCode", this.SpareCode), //new SqlParameter("@SAP_Sales_Order",this.SAP_Sales_Order), //new SqlParameter("@SIMS_Indent_No",this.SIMS_Indent_No), new SqlParameter("@LocId", this.LocId), new SqlParameter("@Qty", this.Qty), new SqlParameter("@CGInvoice", this.CGInvoice), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", Convert.ToInt32("1")), new SqlParameter("@Type", this.ActionType) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSqlDAL.ExecuteNonQuery(CommandType.StoredProcedure, "uspStockUpdateMaster", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@Loc_Code", this.Loc_Code), new SqlParameter("@Loc_Name", this.Loc_Name), new SqlParameter("@Engineer_Code", this.Engineer_Code), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), //new SqlParameter("@IsDefault_Loc",this.IsDefault_Loc), new SqlParameter("@Loc_Id", this.Loc_Id) }; if (this.Engineer_Code.Trim().ToLower() == "select") { sqlParamI[7].Value = DBNull.Value; } sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspASCLocationMaster", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@SpareConsume_Id", this.SpareConsume_Id), new SqlParameter("@SpareConsume_Code", this.SpareConsume_Code), new SqlParameter("@SpareConsume_Desc", this.SpareConsume_Desc), new SqlParameter("@Action_Type", this.Action_Type), new SqlParameter("@Active_Flag", Convert.ToInt32(this.ActiveFlag)), }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareConsume", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@Loc_Id", this.Loc_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@Lead_Time", this.Lead_Time), new SqlParameter("@AVGConsumption_Per_Day", this.AVGConsumption_Per_Day), new SqlParameter("@Safety_Percentage", this.Safety_Percentage), new SqlParameter("@Reorder_Trigger", this.Reorder_Trigger), new SqlParameter("@Recommended_Stock", this.Recommended_Stock), new SqlParameter("@Order_Quantity", this.Order_Quantity), new SqlParameter("@Min_Order_Quantity", this.Min_Order_Quantity), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@ASC_Spec_Spare_Id", this.ASC_Spec_Spare_Id) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspASCSpecificSpareMaster", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@Transaction_No", this.AutoGeneratedNumber), new SqlParameter("@Asc_Code", this.Asc_Code), new SqlParameter("@ProductDivision", this.ProductDivision_Id), new SqlParameter("@Mov_Type_Id", this.Mov_Type_Id), new SqlParameter("@Mov_Type_Text", this.Mov_Type_Text), new SqlParameter("@Vendor_Id", this.VendorId), new SqlParameter("@SpareId", this.SpareId), new SqlParameter("@Loc_Id", this.Loc_Id), new SqlParameter("@Def_Loc_Id", this.Def_Loc_Id), new SqlParameter("@Current_Stock", this.CurrentStock), new SqlParameter("@Quantity", this.Quantity), new SqlParameter("@QtyAsPerLocation", this.StockAsPerLocation), new SqlParameter("@Action_Type_Id", this.Action_Type_Id), new SqlParameter("@Comments", this.Comments), new SqlParameter("@EmpCode", Membership.GetUser().UserName.ToString()) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareSalePurchaseByASC", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut",SqlDbType.VarChar,200), new SqlParameter("@Return_Value",SqlDbType.Int), new SqlParameter("@Type",strType), new SqlParameter("@EmpCode",this.EmpCode), new SqlParameter("@Vendor_Id",this.Vendor_Id), new SqlParameter("@Vendor_Code",this.Vendor_Code), new SqlParameter("@Vendor_Name",this.Vendor_Name), new SqlParameter("@Branch_Sno",this.Branch_ID), new SqlParameter("@Address",this.Address), new SqlParameter("@Active_Flag",Convert.ToInt32(this.ActiveFlag)), }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspVendorMaster", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return strMsg; }
public void SaveData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", this.ActionType), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", 1), new SqlParameter("@ASC_Code", this.ASC_Code), new SqlParameter("@Transaction_Date", this.Transaction_Date), new SqlParameter("@Transaction_No_Auto", this.AutoGeneratedNumber), new SqlParameter("@CGL_Branch_Auto", this.CGL_Branch_Auto), new SqlParameter("@CG_Engineer_Name", this.CG_Engineer_Name), new SqlParameter("@Claim_No", this.Claim_No), new SqlParameter("@Spare_Code", this.Spare_Code), new SqlParameter("@Spare_Description", this.Spare_Description), new SqlParameter("@UOM", this.UOM), new SqlParameter("@Defective_Loc_Code", this.Defective_Loc_Code), new SqlParameter("@Stock", this.Stock), new SqlParameter("@Destroyed_Qty", this.Destroyed_Qty), new SqlParameter("@Balanced_Qty", this.Balanced_Qty) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspDestructionDefectiveSpares", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public void UpdateData() { SqlParameter[] sqlParam = { new SqlParameter("@internalbillno", this.billno), new SqlParameter("@destroyedby", this.destroyedby), new SqlParameter("@ComplaintNo", this.ComplaintNo), new SqlParameter("@Type", "UPDATE_DATA"), }; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspDestructibleSpareAndServiceActivityList", sqlParam); }
public string Update() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", "UPDATE_DATA"), new SqlParameter("@challanno", this.challanno), new SqlParameter("@challanby", this.ChallanBy), new SqlParameter("@challandate", this.challandate), new SqlParameter("@transportationdetail", this.TransportationDetails), new SqlParameter("@DefId", this.DefId) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspDefectiveSpareChallan", sqlParamI); strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
// Bhawesh 27-28 Sep 12 public void SaveData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Type", "INSERT_SPARE_REQUIREMENT"), new SqlParameter("@Asc_Code", this.Asc_Code), new SqlParameter("@ProductDivision", this.ProductDivisionId), new SqlParameter("@Product", this.ProductId), new SqlParameter("@ComplaintNo", this.Complaint_No), new SqlParameter("@SpareId", this.SpareId), new SqlParameter("@CurrentStock", this.CurrentStock), new SqlParameter("@Proposed_Qty", this.ProposedQuantity), new SqlParameter("@Active_Flag", this.ActiveFlag), new SqlParameter("@EmpCode", Membership.GetUser().UserName.ToString()), }; sqlParamI[0].Direction = ParameterDirection.Output; DataTable dt = DataTableSpareReqComplt; int suc = 0; foreach (DataRow dr in dt.Rows) { sqlParamI[2].Value = Convert.ToInt32(dr["ASC_Id"]); sqlParamI[3].Value = Convert.ToInt32(dr["ProductDivision_Id"]); sqlParamI[4].Value = Convert.ToInt32(dr["Product_SNo"]); sqlParamI[5].Value = dr["Complaint_No"].ToString(); sqlParamI[6].Value = Convert.ToInt32(dr["Spare_Id"]); sqlParamI[7].Value = Convert.ToInt32(dr["Current_Stock"]); sqlParamI[8].Value = Convert.ToInt32(dr["Proposed_Qty"]); sqlParamI[9].Value = dr["Active_Flag"].Equals("1"); suc = objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareRequirementForComplaint", sqlParamI); this.MessageOut = Convert.ToString(sqlParamI[0].Value); if (MessageOut != "") { break; } } sqlParamI = null; }
/// <summary> /// Activity can be deleted By EICs from Claim Approval Screen /// </summary> /// <param name="ActivityID"></param> /// <returns></returns> public int DeleteActivity() { SqlParameter[] sqlParamS = { new SqlParameter("@CGuser", this.CGuser), new SqlParameter("@Activity_Cost_Complaint_ID", Activity_Cost_Complaint_ID), new SqlParameter("@DeletionReason", Deletion_Reason), new SqlParameter("@ComplaintNo", this.Complaint_No), new SqlParameter("@Type", "DEL_ACTIVITY_ID") }; return(objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspClaimApprovalWarrantyComplaints", sqlParamS)); }
//Save new cost center public void SaveCostCenter() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Cost_Center_Code", this.CostCenterCode), new SqlParameter("@Cost_Center_Desc", this.CostCenterDesc), new SqlParameter("@Division", this.DivisionID), new SqlParameter("@BA_Code", this.BACode), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", Convert.ToInt32(this.Active_Flag)), new SqlParameter("@Type", this.Type) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSqlDAL.ExecuteNonQuery(CommandType.StoredProcedure, "uspSAPCostCenter", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
// The below will delete record and takes first paramenter as Stored Proc or Sql Query // second argument as whether this is proc or query i.e. true for stored proc and flase for sql query // third parameter is passed sql parameters public int DeleteRecord(string strProcOrQuery, bool isProc, SqlParameter sqlParam) { try { if (isProc) { objSql.ExecuteNonQuery(CommandType.StoredProcedure, strProcOrQuery, sqlParam); } else { objSql.ExecuteNonQuery(CommandType.Text, strProcOrQuery, sqlParam); } return(1); } catch (Exception ex) { SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString()); return(0); } }
//end by rajiv #region Reject Complaint public void RejectComplaintValue() { SqlParameter[] sqlParamS = { new SqlParameter("@IdComplaint", this.ComplaintId), new SqlParameter("@RejectionReason", this.Reason), new SqlParameter("@ApprovedBy", this.ApprovedBy), new SqlParameter("@ComplaintNo", this.complaint_no), new SqlParameter("@Type", "REJECT_COMPLAINT"), new SqlParameter("@EmpCode", Membership.GetUser().UserName.ToString()) }; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareConsumptionAndActivityDetails", sqlParamS); sqlParamS = null; }
public void SaveSpareMaster() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@ReturnSpareId", SqlDbType.Int), new SqlParameter("@SpareId", this.SpareId), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@SpareCode", this.SpareCode), new SqlParameter("@SpareDesc", this.SpareDesc), new SqlParameter("@UOM", this.UOM), new SqlParameter("@Listprice", this.Listprice), new SqlParameter("@Materialgroup", this.Materialgroup), new SqlParameter("@MaterialType", this.MaterialType), new SqlParameter("@SpareObsolete", this.SpareObsolete), new SqlParameter("@SpareMoving", this.SpareMoving), new SqlParameter("@SpareValue", this.SpareValue), new SqlParameter("@EssentialSpare", this.EssentialSpare), new SqlParameter("@SpareType", this.SpareType), new SqlParameter("@MinimumOrder", this.MinimumOrder), new SqlParameter("@Discount", this.Discount), new SqlParameter("@fpSparephoto", this.fpSparephoto), new SqlParameter("@Sparedisposal", this.Sparedisposal), new SqlParameter("@SpareAction", this.SpareAction), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", Convert.ToInt32(this.ActiveFlag)), new SqlParameter("@Type", this.ActionType) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; sqlParamI[2].Direction = ParameterDirection.Output; objSqlDAL.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareMaster", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); this.SpareId = sqlParamI[2].Value.ToString(); sqlParamI = null; }
public void SaveData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", this.ActionType), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", 1), new SqlParameter("@Transaction_No", this.AutoGeneratedNumber), new SqlParameter("@Transaction_Date", this.Transaction_Date), new SqlParameter("@SIMS_Indent_No", this.SIMS_Indent_No), new SqlParameter("@PO_Number", this.PO_Number), new SqlParameter("@SAP_Sales_Order", this.SAP_Sales_Order), new SqlParameter("@SAP_Invoice_No", this.SAP_Invoice_No), new SqlParameter("@SAP_Invoice_Date", this.SAP_Invoice_Date), new SqlParameter("@SAP_Challan_No", this.SAP_Challan_No), new SqlParameter("@SAP_Challan_Date", this.SAP_Challan_Date), new SqlParameter("@Is_Part_Delivery", this.Is_Part_Delivery), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@Spare_Id", this.Spare_Id), new SqlParameter("@Ordered_Qty", this.Ordered_Qty), new SqlParameter("@Dispatched_Qty", this.Dispatched_Qty), new SqlParameter("@Received_Qty", this.Received_Qty), new SqlParameter("@Pending_Qty", this.Pending_Qty), new SqlParameter("@Short_Qty", this.Short_Qty), new SqlParameter("@Inter_SAP_Invoice_ID", Convert.ToInt32(this.Inter_SAP_Invoice_ID)), new SqlParameter("@Defective_Qty", this.Defective_Qty) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSalesOrderReceipts", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public string UpdateDraftIndentData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Draft_No", this.Draft_No), new SqlParameter("@PO_Number", this.PO_Number), new SqlParameter("@ASC_Id", this.ASC_Id), new SqlParameter("@Sales_Order_Type_Id", this.Sales_Order_Type_Id), new SqlParameter("@Tax_Form_Type_Id", this.Tax_Form_Type_Id), new SqlParameter("@Inco_Terms_Id", this.Inco_Terms_Id), new SqlParameter("@Consignee_Details", this.Consignee_Details), new SqlParameter("@AddressLine1", this.AddressLine1), new SqlParameter("@AddressLine2", this.AddressLine2), new SqlParameter("@AddressLine3", this.AddressLine3), new SqlParameter("@City", this.City), new SqlParameter("@State", this.State), new SqlParameter("@Pin_Code", this.Pin_Code), new SqlParameter("@ECC_No", this.ECC_No), new SqlParameter("@TIN_Number", this.TIN_Number) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspSpareRequirementIndentConfirm", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public int UpdateData() { int count = 0; SqlParameter[] sqlParam = { new SqlParameter("@Internal_Bill_No", this.BillNo), new SqlParameter("@BillBy", this.BillBy), new SqlParameter("@ComplaintNo", this.ComplaintNo), new SqlParameter("@MISComplaint_Id", this.MISComplaint_Id), new SqlParameter("@Item_Type", this.Item_Type), new SqlParameter("@Item_Id", this.Item_Id), new SqlParameter("@ReturnValue", SqlDbType.Int), new SqlParameter("@Type", "UPDATE_DATA"), }; sqlParam[6].Direction = ParameterDirection.Output; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspGenerateInternalBill", sqlParam); count = int.Parse(sqlParam[6].Value.ToString()); return(count); }
public string SaveData(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Type", strType), new SqlParameter("@SC_SNo", this.SCSNo), new SqlParameter("@SC_Code", this.SCCode), new SqlParameter("@SC_UserName", this.SCUserName), new SqlParameter("@SC_Name", this.SCName), new SqlParameter("@SAP_Customer_Code", this.SAP_Customer_Code), new SqlParameter("@SAP_Vendor_Code", this.SAP_Vendor_Code), new SqlParameter("@Contact_Person", this.ContactPerson), new SqlParameter("@Region_SNo", this.BranchSNo), new SqlParameter("@Branch_SNo", this.BranchSNo), new SqlParameter("@State_SNo", this.StateSno), new SqlParameter("@City_SNo", this.CitySNo), new SqlParameter("@Address1", this.Address1), new SqlParameter("@Address2", this.Address2), new SqlParameter("@EmailID", this.EmailID), new SqlParameter("@PhoneNo", this.PhoneNo), new SqlParameter("@MobileNo", this.MobileNo), new SqlParameter("@Preference", this.Prefernce), new SqlParameter("@SpecialRemarks", this.SpecialRemarks), new SqlParameter("@FaxNo", this.FaxNo), new SqlParameter("@Weekly_Off_Day", this.WeekOffDay), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Branch_Plant_SNo", Convert.ToInt32(this.BranchPlantSNo)), // new SqlParameter("@CreditNote_Threshold_Amount",Convert.ToDecimal(this.CreditNoteThresholdAmount)), //new SqlParameter("@CreditNote_Generation_Day",Convert.ToInt32(this.CreditNoteGenerationDay)), new SqlParameter("@ECC_Number", this.ECC_Number), new SqlParameter("@TIN_Number", this.TIN_Number) }; sqlParamI[0].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspServiceContractorMaster", sqlParamI); strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public void SaveParameterMaster() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@ParameterId", this.ParameterId), new SqlParameter("@ProductDivision_Id", this.ProductDivision_Id), new SqlParameter("@ParameterCode", this.ParameterCode), new SqlParameter("@ParameterDesc", this.ParameterDesc), new SqlParameter("@CreatedBy", this.ActionBy), new SqlParameter("@Active_Flag", Convert.ToInt32(this.ActiveFlag)), new SqlParameter("@Type", this.ActionType) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSqlDAL.ExecuteNonQuery(CommandType.StoredProcedure, "uspParameterMaster", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[1].Value.ToString()); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }