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);
}