string strQuery; // For storing sql query public void SaveData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@return_value", SqlDbType.Int, 20), new SqlParameter("@BaseLineId", this.BaseLineId), new SqlParameter("@SplitComplaint_RefNo", this.SplitComplaint_RefNo), new SqlParameter("@CustomerId ", this.CustomerId), new SqlParameter("@Complaint_RefNo", this.Complaint_RefNo), new SqlParameter("@SeqNo", this.SeqNo), new SqlParameter("@ProductDivision_Sno", this.ProductDivision_Sno), new SqlParameter("@ProductLine_Sno", this.ProductLine_Sno), new SqlParameter("@ProductGroup_SNo", this.ProductGroup_SNo), new SqlParameter("@Product_SNo", this.Product_SNo), new SqlParameter("@SC_SNo", this.SC_SNo), new SqlParameter("@ModeOfReceipt_SNo", this.ModeOfReceipt_SNo), new SqlParameter("@Quantity", this.Quantity), new SqlParameter("@InvoiceNo", this.InvoiceNo), new SqlParameter("@InvoiceDate", this.InvoiceDate), new SqlParameter("@CallStatus", this.CallStatus), new SqlParameter("@Type", this.Type), new SqlParameter("@ModifiedBy", this.EmpID), }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSqlDataAccessLayer.ExecuteNonQuery(CommandType.StoredProcedure, "uspBaseComDet", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { 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("@Category_Name", this.CategoryDesc), new SqlParameter("@Unit_Sno", this.UnitSno), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Category_ID", this.CategorySNo), new SqlParameter("@BusinessLine_SNo", this.BusinessLine_Sno) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspCategoryMaster", 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); }
protected void imgBtnAdd_Click(object sender, EventArgs e) { try { if (IsValid()) { foreach (GridViewRow item in gvSummary.Rows) { CheckBox chk = (CheckBox)item.FindControl("chkSelect"); if (chk.Checked) { string complaint_no = item.Cells[2].Text; TextBox txt = (TextBox)item.FindControl("txtcomment"); string comment = txt.Text; int msg = objSqlDataAccessLayer.ExecuteNonQuery(CommandType.Text, "update tbl_ComplaintActivityTypeFan set IsReApprovalSent=1,ASCComment='" + comment + "' where Complaint_no ='" + complaint_no + "'"); } } lblMessage.Text = ""; lblSuccess.Text = "Sent For Approval"; BindSummaryGrid(); } else { lblMessage.Text = "Please Enter Comment in Selected Complaint"; } } catch (Exception ex) { SIMSCommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString()); } }
public void SaveCustomerData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), //new SqlParameter("@Complaint_RefNoOUT",SqlDbType.VarChar,20), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@PartyCode", this.Party_Code), new SqlParameter("@Type", this.Type), new SqlParameter("@SiteDetail", this.SiteDetail), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Country_Sno", this.Country_Sno), new SqlParameter("@State_Sno", this.State_Sno), new SqlParameter("@City_Sno", this.City_Sno), new SqlParameter("@ContactPersonDetail", this.ContactPersonDetail) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspRequestRegistrationMTO", sqlParamI); this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.MessageOut = sqlParamI[0].Value.ToString(); } else if (int.Parse(sqlParamI[1].Value.ToString()) == 1) { this.CustomerId = 1; //Convert.ToInt64(sqlParamI[0].Value.ToString()); } sqlParamI = null; }
public void UpdateCallingStatus() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@return_value", SqlDbType.Int, 20), new SqlParameter("@CCRemarks", this.CCRemarks), new SqlParameter("@AppointDate", this.AppointDate), new SqlParameter("@AppointTime", this.AppointTime), new SqlParameter("@UserName", this.EmpCode), new SqlParameter("@baselineID", this.BaseLineID), new SqlParameter("@SMS_ID", this.SMS_SNo), new SqlParameter("@IsFalseUpdated", this.IsFalseUpdated), new SqlParameter("@IsAddrUpdated", this.IsAddrUpdated), new SqlParameter("@Type", "UPDATECALLSTATUSONAPP") }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspOutboundSMS", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.MessageOut = sqlParamI[0].Value.ToString(); } sqlParamI = null; }
public void UpdateComment(string strComplaintRefNo, string strSplitNo, string strComment) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", this.Type), new SqlParameter("@SplitNo", int.Parse(strSplitNo)), new SqlParameter("@ComplaintRefNo", strComplaintRefNo), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Comment", strComment), new SqlParameter("@IsToRegister", this.IsToRegister) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspCallReg", sqlParamI); this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.MessageOut = sqlParamI[0].Value.ToString(); } sqlParamI = null; }
/// <summary> /// Call Registration /// </summary> /// <param name="calltype"></param> /// <param name="custname"></param> /// <param name="contactNo"></param> /// <param name="email"></param> /// <param name="state"></param> /// <param name="RefComplaintNo"></param> /// <param name="city"></param> /// <param name="comment"></param> /// <param name="loggedInUser"></param> /// <param name="CallRefNo"></param> /// <returns></returns> public int RegisterCall(int calltype, string custname, string contactNo, string email, string state, string RefComplaintNo, string city, string comment, string loggedInUser, out string CallRefNo, bool Escalated) { int suc = 0; CallRefNo = ""; SqlParameter[] param = { new SqlParameter("@Type", "RegisterCall"), new SqlParameter("@CallTypeID", calltype), new SqlParameter("@State_Sno", state), new SqlParameter("@City_Sno", city), new SqlParameter("@CallerName", custname), new SqlParameter("@ContactNo", contactNo), new SqlParameter("@EmailID", email), new SqlParameter("@Comment", comment), new SqlParameter("@RegisteredBy", loggedInUser), new SqlParameter("@ComplaintRefNo_Ref", RefComplaintNo), new SqlParameter("@CallRefNo", SqlDbType.VarChar,15), new SqlParameter("@IsEscalated", SqlDbType.Bit) }; param[10].Direction = ParameterDirection.Output; param[11].Value = Escalated; suc = objSql.ExecuteNonQuery(CommandType.StoredProcedure, "RegisterCall", param); CallRefNo = param[10].Value.ToString(); return(suc); }
// Added by Bhawesh 27 Nov 12 public void UpdateCustomerData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@CustomerId", this.CustomerId), new SqlParameter("@Prefix", this.Prefix), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Address1", this.Address1), new SqlParameter("@Address2", this.Address2), new SqlParameter("@LandMark", this.Landmark), new SqlParameter("@AltTelNumber", this.AltTelNumber), new SqlParameter("@City_Sno", this.City), new SqlParameter("@Country_Sno", this.Country), new SqlParameter("@Customer_Type", this.Customer_Type), new SqlParameter("@Company_Name", this.Company_Name), new SqlParameter("@Email", this.Email), new SqlParameter("@Extension", this.Extension), new SqlParameter("@Fax", this.Fax), new SqlParameter("@FirstName", this.FirstName), new SqlParameter("@LastName", this.LastName), new SqlParameter("@State_Sno", this.State), new SqlParameter("@PinCode", this.PinCode), }; sqlParamI[0].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "Usp_UPDATE_CUSTOMER_DATA", sqlParamI); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public void SaveDefectDetails() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@Type", this.Type), new SqlParameter("@Application_Type", this.Application_Type), new SqlParameter("@Application", this.Application), new SqlParameter("@Voltage_Observed", this.Voltage_Observed), new SqlParameter("@Current_Observed", this.Current_Observed), new SqlParameter("@CP", this.CP), new SqlParameter("@CP_Make", this.CP_Make), new SqlParameter("@Panel_HP", this.Panel_HP), new SqlParameter("@Power_Supply", this.Power_Supply), new SqlParameter("@Size", this.Size), new SqlParameter("@Length", this.Length), new SqlParameter("@Op_Head", this.Op_Head), new SqlParameter("@Suction_Side", this.Suction_Side), new SqlParameter("@Delivery_Side", this.Delivery_Side), new SqlParameter("@WDG_Burn", this.WDG_Burn), new SqlParameter("@WDG_Melt", this.WDG_Melt), new SqlParameter("@interturn_Short", this.interturn_Short), //new SqlParameter("@WDG_flash",this.WDG_flash), //new SqlParameter("@WDG_pumpture",this.WDG_pumpture), new SqlParameter("@Cable_Joint", this.Cable_Joint), new SqlParameter("@Complaint_Split", this.Complaint_No), new SqlParameter("@Created_By", this.UserName) }; sqlParamI[0].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspPumpDefect", sqlParamI); this.MessageOut = sqlParamI[0].Value.ToString(); sqlParamI = null; }
public void ApplyRoleUser(string strRole, string strUserName, string strLoginUserName, string strType) { SqlParameter[] sqlParamG = { new SqlParameter("@Type", strType), new SqlParameter("@RoleName", strRole), new SqlParameter("@UserName", strUserName), new SqlParameter("@EmpCode", strLoginUserName) }; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspEditUserAndRoleMaster", sqlParamG); }
public void SaveCustomerData() { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@Complaint_RefNoOUT", SqlDbType.VarChar, 20), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@CustomerId", this.CustomerId), new SqlParameter("@Dealer_Code", this.DealerId), new SqlParameter("@Dealer_Name", this.DealerName), new SqlParameter("@Dealer_email", this.DealerEmail), new SqlParameter("@Type", this.Type), new SqlParameter("@Prefix", this.Prefix), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@UpdateCustDeatil", this.UpdateCustDeatil), new SqlParameter("@Address1", this.Address1), new SqlParameter("@Address2", this.Address2), new SqlParameter("@LandMark", this.Landmark), new SqlParameter("@AltTelNumber", this.AltTelNumber), new SqlParameter("@City_Sno", this.City), new SqlParameter("@City_Other", this.CityOther), new SqlParameter("@Country_Sno", this.Country), new SqlParameter("@Customer_Type", this.Customer_Type), new SqlParameter("@Company_Name", this.Company_Name), new SqlParameter("@Email", this.Email), new SqlParameter("@Extension", this.Extension), new SqlParameter("@Fax", this.Fax), new SqlParameter("@FirstName", this.FirstName), new SqlParameter("@LastName", this.LastName), new SqlParameter("@Language_Sno", int.Parse(this.Language)), new SqlParameter("@State_Sno", this.State), new SqlParameter("@UniqueContact_No", this.UniqueContact_No), new SqlParameter("@PinCode", this.PinCode), // Added by Gaurav Garg on 5 Nov for MTO new SqlParameter("@PartyCode", this.PartyCode) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.Output; sqlParamI[2].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspCallReg", sqlParamI); this.ReturnValue = int.Parse(sqlParamI[2].Value.ToString()); if (int.Parse(sqlParamI[2].Value.ToString()) == -1) { this.MessageOut = sqlParamI[0].Value.ToString(); } else if (int.Parse(sqlParamI[2].Value.ToString()) == 1) { this.CustomerId = Convert.ToInt64(sqlParamI[0].Value.ToString()); } sqlParamI = null; }
public void SaveComplaint(string strType) { SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000), new SqlParameter("@WebRequest_RefNo", SqlDbType.VarChar, 20), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@Prefix", this.Prefix), new SqlParameter("@FirstName", this.FileName), new SqlParameter("@LastName", this.LastName), new SqlParameter("@Address", this.Address), new SqlParameter("@Company_Name", this.Company_Name), new SqlParameter("@Contact_No", this.Contact_No), new SqlParameter("@Country_Sno", this.Country_Sno), new SqlParameter("@State_Sno", this.State_Sno), new SqlParameter("@City_Sno", this.City_Sno), new SqlParameter("@Email", this.Email), new SqlParameter("@Feedback_Type", this.Feedback_Type), new SqlParameter("@Feedback", this.Feedback), new SqlParameter("@ProductDivisionId", this.ProductDivisionId), new SqlParameter("@ProductLineId", this.ProductLineId), new SqlParameter("@Rating_Voltage", this.Rating_Voltage), new SqlParameter("@Manufacturer_Serial_No", this.Manufacturer_Serial_No), new SqlParameter("@Manufacture_Year", this.Manufacture_Year), new SqlParameter("@Site_Location", this.Site_Location), new SqlParameter("@Nature_of_Complaint", this.Nature_of_Complaint), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@CGExe_Feedback", this.CGExe_Feedback), new SqlParameter("@CGExe_Comment", this.CGExe_Comment), new SqlParameter("@WSCCustomerId", this.WSCCustomerId) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.Output; sqlParamI[2].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspWSCCustomerRegistration", sqlParamI); this.ReturnValue = Convert.ToInt32(sqlParamI[2].Value.ToString()); if (Convert.ToInt32(sqlParamI[2].Value.ToString()) == -1) { this.MessageOut = sqlParamI[0].Value.ToString(); } else if (Convert.ToInt32(sqlParamI[2].Value.ToString()) == 1) { this.WebRequest_RefNo = sqlParamI[1].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("@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", this.Rating_Status), new SqlParameter("@ProductGroup_SNo", this.ProductGroup_SNo), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Product_SNo", this.ProductSNo), new SqlParameter("@ProductType_Sno", this.ProductType_Sno) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspProductMaster", 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("@Company_Code", this.CompanyCode), new SqlParameter("@Company_Name", this.CompanyName), new SqlParameter("@Address1", this.Address1), new SqlParameter("@Address2", this.Address2), new SqlParameter("@Address3", this.Address3), new SqlParameter("@Pin_Code", this.Pin_Code), new SqlParameter("@Country_SNo", this.Country_Sno), new SqlParameter("@State_SNo", this.State_Sno), new SqlParameter("@City_SNo", this.City_SNo), new SqlParameter("@Phone", this.Phone), new SqlParameter("@Fax", this.Fax), new SqlParameter("@Url", this.URL), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Company_SNo", this.CompanySNo) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspCompanyMaster", 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 GetOldCallStatusId(string complaintRefNo, int splitComplaintRefNo) { int oldStatusid = 0; SqlParameter[] param = { new SqlParameter("@Type", "GETOLDSTATUSID"), new SqlParameter("@ComplaintRefNo", complaintRefNo), new SqlParameter("@SplitComplaintRefNo", splitComplaintRefNo), new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000) }; param[3].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspGetComplaintForRSM", param); oldStatusid = int.Parse(param[3].Value.ToString()); return(oldStatusid); }
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("@ProductLine_SNo", this.ProductLineSNo), new SqlParameter("@productdivision_sno", this.Unit_Sno), new SqlParameter("@Defect_Category_SNo", this.DefectCategorySNo), new SqlParameter("@BusinessLine_SNo", this.Businessline_Sno), new SqlParameter("@BladeVendor", this.VendorName), new SqlParameter("@Identification", this.VendorSymbol), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Defect_SNo", this.DefectSNo), new SqlParameter("@Ident_Sno", this.Ident_Sno), new SqlParameter("@WindingUnit", this.WindingUnit) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspBladeVendorMaster", 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("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@Dealer_Code", this.DealerCode), new SqlParameter("@Dealer_Name", this.DealerDesc), new SqlParameter("@DealerEmail", this.DealerEmail), new SqlParameter("@StateCode", this.StateCode), new SqlParameter("@Address", this.Address), new SqlParameter("@CityCode", this.CityCode), new SqlParameter("@Region", this.region), new SqlParameter("@Branch", this.BranchCode), new SqlParameter("@Country", this.CountryCode), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Dealer_SNo", this.DealerSNo) }; sqlParamI[0].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspDealerMaster", sqlParamI); strMsg = sqlParamI[0].Value.ToString(); sqlParamI = null; return(strMsg); }
public string SaveLandMarkData(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("@LandMark_Code", this.LandMarkCode), new SqlParameter("@LandMark_Desc", this.LandMarkDesc), new SqlParameter("@Territory_SNo", this.TerritorySNo), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Landmark_SNo", this.LandMarkSNo) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspLandMarkMaster", 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("@State_Code", this.StateCode), new SqlParameter("@Country_SNo", this.CountrySNo), new SqlParameter("@Region_SNo", this.RegionSno), new SqlParameter("@State_Desc", this.StateDesc), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@State_SNo", this.StateSNo), new SqlParameter("@MTO_Status_Code", this.MTOStateCode), new SqlParameter("@ShowState", this.ShowState) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspStateMaster", 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 static Boolean SendSMS(string strMobileNo, string strComplaint_RefNo, string strReceiver_Id, string strMDateYYYYMMDD, string strMFrom4Char, string strMText166Char, string strFULLMESS, string strReceiverType3Char, string happycode) { SqlDataAccessLayer objSqlDataAccessLayer; try { int intReturn; SqlParameter[] sqlParamM = { new SqlParameter("@MobileNo", strMobileNo), new SqlParameter("@Complaint_RefNo", strComplaint_RefNo), new SqlParameter("@Receiver_Id", strReceiver_Id), new SqlParameter("@MDateYYYYMMDD", strMDateYYYYMMDD), new SqlParameter("@MFrom4Char", strMFrom4Char), new SqlParameter("@MText166Char", strMText166Char), new SqlParameter("@FULLMESS", strFULLMESS), new SqlParameter("@ReceiverType", strReceiverType3Char), new SqlParameter("@Status", "N"), new SqlParameter("@happycode", happycode) }; objSqlDataAccessLayer = new SqlDataAccessLayer(); intReturn = objSqlDataAccessLayer.ExecuteNonQuery(CommandType.StoredProcedure, "Usp_SMS_CUS", sqlParamM); sqlParamM = null; return(true); } catch (Exception ex) { //Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page // trace, error message CommonClass.WriteErrorErrFile("SendSMScus", ex.StackTrace.ToString() + "-->" + ex.Message.ToString()); return(false); } }
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("@Region_SNo", this.RegionSNo), new SqlParameter("@State_SNo", this.StateSNo), new SqlParameter("@City_SNo", this.CitySNo), new SqlParameter("@Branch_Code", this.BranchCode), new SqlParameter("@Branch_Name", this.BranchName), new SqlParameter("@BranchAddress", this.BranchAddress), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Branch_SNo", this.BranchSNo), new SqlParameter("@DocType", this.DocType) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspBranchMaster", 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("@RegionId", this.RegionId), new SqlParameter("@Branch_sno", this.Branch_sno), new SqlParameter("@StateId", this.StateId), new SqlParameter("@ProductdivisionId", this.ProductdivisionId), new SqlParameter("@To_UserId", this.To_UserId), new SqlParameter("@CC_UserId", this.CC_UserId), new SqlParameter("@ElaspTimeMatrix1", this.ElaspTimeMatrix1), new SqlParameter("@To_UserId1", this.To_UserId1), new SqlParameter("@CC_UserId1", this.CC_UserId1), new SqlParameter("@ElaspTimeMatrix2", this.ElaspTimeMatrix2), new SqlParameter("@To_UserId2", this.To_UserId2), new SqlParameter("@CC_UserId2", this.CC_UserId2), new SqlParameter("@Active_Flag", Convert.ToInt32(this.ActiveFlag)), new SqlParameter("@EscalationId", this.EscalationId) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspWSCEscalationMatrix", 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("Attribute_Desc", this.AttributeDesc), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Attribute_Sno", this.AttributeSno), // Added By Gaurav Garg on 20 Oct 09 For MTO new SqlParameter("@BusinessLine_SNo", this.BusinessLine_Sno) // END }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspAttributeMaster", 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("@Type", strType), new SqlParameter("@EmpCode", this.EmpCode), new SqlParameter("@BA_Code", this.BACode), new SqlParameter("@BA_Desc", this.BADesc), new SqlParameter("@SBU_Sno", this.SBUSno), new SqlParameter("@SBU_Desc", this.SBUDesc), new SqlParameter("@Company_SNo", this.CompanySNo), new SqlParameter("@Company_Name", this.CompanyName), new SqlParameter("@BA_STNo", this.BASTNo), new SqlParameter("@BA_CSTNo", this.BACSTNo), new SqlParameter("@BA_ExciseNo", this.BAExciseNo), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@BA_Sno", this.BASno) }; sqlParamI[0].Direction = ParameterDirection.Output; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspBusinessAreaMaster", sqlParamI); 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("@Attribute_Sno", this.Attribute_Sno), new SqlParameter("@ProductLine_SNo", this.ProductLine_SNo), new SqlParameter("@AttrDefaultValue", this.AttrDefaultValue), new SqlParameter("@AttrRequired", this.AttrRequired), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@AttrMapping_Sno", this.AttrMapping_Sno), // Added by Gaurav Garg 20 OCT 09 for MTO new SqlParameter("@BusinessLine_SNo", this.BusinessLine_Sno) // END }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "UspAttributeMap", 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("@Response_Code", this.ResponseCode), new SqlParameter("@Response_Desc", this.ResponseDesc), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Response_id", this.ResponseId) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objsql.ExecuteNonQuery(CommandType.StoredProcedure, "uspResponseMaster", 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("@RoleName", this.RoleName), new SqlParameter("@Unit_SNo", this.Unit_SNo), new SqlParameter("@Unit_SNos", this.Unit_SNos), // 8 jun 12 new SqlParameter("@Branch_SNo", this.Branch_SNo), new SqlParameter("@UserID", this.UserID), new SqlParameter("@Region_SNo", this.Region_SNo), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Organization_SNo", this.Organization_SNo), // Added by Gaurav Garg 20 OCT 09 for MTO new SqlParameter("@BusinessLine_SNo", this.BusinessLine_Sno) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspOrgMaster", sqlParamI); if (int.Parse(sqlParamI[1].Value.ToString()) == -1) { this.ReturnValue = int.Parse(sqlParamI[1].Value.ToString()); } this.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("@Return_Value",SqlDbType.Int), new SqlParameter("@EmpCode", this._EmpCode), new SqlParameter("@UserName", this._UserName), // new SqlParameter("@Branch_Sno",int.Parse(this._Branch)), new SqlParameter("@Unit_SNo", this._UnitSNo), new SqlParameter("@StatusId", this._StatusId), new SqlParameter("@Callstage", this._Callstage), new SqlParameter("@stageDesc", this._stageDesc), new SqlParameter("@BHQ_Status", this._BHQStatus), new SqlParameter("@SC_RepairLocation", this._SCRepairLocation), new SqlParameter("@Duration_Hours", this._DurationHours), new SqlParameter("@Escallation_Role", this._EscallationRole), new SqlParameter("@Active_Flag", int.Parse(this._ActiveFlag)), new SqlParameter("@Escallation_SNo", this._EscallationSNo), new SqlParameter("@IsClosure", this.IsClosure) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspEscallationMaster", 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 SaveData(string strType)//(string strType,string ConStr) { // SqlDataAccessLayer Sql = new SqlDataAccessLayer(ConStr); SqlDataAccessLayer Sql = new SqlDataAccessLayer(); SqlParameter[] sqlParamI = { new SqlParameter("@MessageOut", SqlDbType.VarChar, 200), new SqlParameter("@Return_Value", SqlDbType.Int), new SqlParameter("@Type", strType), new SqlParameter("@StatusCode", this.StatusCode), new SqlParameter("@MessageFrom", this.MessageFrom), new SqlParameter("@Operator", this.Operator), new SqlParameter("@Circle", this.Circle), new SqlParameter("@Complaint_refno", this.Complaint_refNo), new SqlParameter("@RequestedUrl", this.RequestedUrl), new SqlParameter("@SMSText", this.SMSText), new SqlParameter("@StatusMsg", this.StatusMessage), new SqlParameter("@ClientIP", this.GetIPAddress()) }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; Sql.ExecuteNonQuery(CommandType.StoredProcedure, "uspInboundSMSBySE", 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(ReturnValue); }
//End #endregion Properties and Variables #region Functions For save data 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("@Unit_Code", this.UnitCode), new SqlParameter("@Unit_Desc", this.UnitDesc), new SqlParameter("@SBU_SNo", this.CompanySNo), new SqlParameter("@Manufacture_Warranty_Period", this.WFManufacture), new SqlParameter("@Purchase_Warranty_Period", this.WFPurchase), new SqlParameter("@Visit_Charge", this.VisitCharge), new SqlParameter("@Active_Flag", int.Parse(this.ActiveFlag)), new SqlParameter("@Unit_SNo", this.UnitSNo), new SqlParameter("@BusniessLine_SNo", this.BusinessLineSNo) /* Commented Bhawesh 7 Feb 13 , * new SqlParameter("@SAP_Division_Code",this.SAP_Division_Code), //Add by Binay-14-07-2010 * new SqlParameter("@Sales_Organisation",this.Sales_Organisation) //Add by Binay-14-07-2010 */ }; sqlParamI[0].Direction = ParameterDirection.Output; sqlParamI[1].Direction = ParameterDirection.ReturnValue; objSql.ExecuteNonQuery(CommandType.StoredProcedure, "uspUnitMaster", 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); }