protected void Page_Load(object sender, EventArgs e)
{
//RegularExpressionValidator2.IsValid = true;
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
sqlParamSrh[4].Value = Membership.GetUser().UserName.ToString();
if (!Page.IsPostBack)
{
TimeSpan duration = new TimeSpan(0, 0, 0, 0);
txtxPurchaseDate.Text = DateTime.Now.Add(duration).ToShortDateString();
objCommonClass.BindDataGrid(gvComm, "uspWSCCustomerRegistration", true, sqlParamSrh, lblRowCount);
//objCommonClass.BindDataGrid(gvComm, "uspWSCCustomerRegistration", true, sqlParamSrh);
ViewState["Column"] = "CreatedDate";
ViewState["Order"] = "desc";
//File Upload Tem Create datatable Grid
DataTable dTableF = new DataTable("tblInsert");
DataColumn dClFileName = new DataColumn("FileName", System.Type.GetType("System.String"));
dTableF.Columns.Add(dClFileName);
ViewState["dTableFile"] = dTableF;
//End
//Hide and Unhide some info
tblInformation.Visible = false;
//End
objwscCustomerComplaint.BindCountry(ddlCountry);
ddlState.Items.Insert(0, new ListItem("Select", "0"));
ddlCity.Items.Insert(0, new ListItem("Select", "0"));
objwscCustomerComplaint.BindFeedbackType(ddlFeedbackType);
objwscCustomerComplaint.BindProductDiv(ddlProductDiv);
ddlProductLine.Items.Insert(0, new ListItem("Select", "0"));
objwscCustomerComplaint.BindCGExeFeedback(ddlGCExecutive);
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Territories to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvTerritory, "uspTerritoryMaster", true, sqlParamSrh, lblRowCount);
objCommonClass.BindCountry(ddlCountry);
ddlState.Items.Insert(0, new ListItem("Select", "Select"));
ddlCity.Items.Insert(0, new ListItem("Select", "Select"));
imgBtnUpdate.Visible = false;
ViewState["Column"] = " Territory_Code";
ViewState["Order"] = "ASC";
string UserName = Membership.GetUser().UserName.ToString();
if (UserName.ToLower() == "cgit" || UserName.ToLower() == "wad")
{
showTR.Visible = true;
}
else
{
showTR.Visible = false;
}
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
#region Common
if (User.IsInRole("CGAdmin"))
{
sqlParamSrh[3].Value = "CGAdmin";
}
else if (User.IsInRole("CCAdmin"))
{
sqlParamSrh[3].Value = "CCAdmin";
}
else if (User.IsInRole("Super Admin"))
{
sqlParamSrh[3].Value = "Super Admin";
}
else
{
sqlParamSrh[3].Value = "";
}
sqlParamSrh[1].Value = ddlSearch.SelectedValue.ToString();
sqlParamSrh[2].Value = txtSearch.Text.Trim();
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
#endregion Common
#region not Postback
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvShowUser, "uspUserLockUnlock", true, sqlParamSrh, lblRowCount);
ViewState["Column"] = "Name";
ViewState["Order"] = "ASC";
}
#endregion not Postback
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
//For Searching
//SqlParameter[] sqlParamSrh =
// {
// new SqlParameter("@Type","SEARCH"),
// new SqlParameter("@Column_name",""),
// new SqlParameter("@SearchCriteria","")
// };
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling CallStatus to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspMisDetail", true);
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvUserType, "uspUserTypeMaster", true, sqlParamSrh);
imgBtnUpdate.Visible = false;
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Batch to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspBatchMaster", true);
imgBtnUpdate.Visible = false;
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvComm, "uspFeedBackAnswerMaster", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Fb_Answer_Scale";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
objCommonClass.BindRegion(ddlRegion);
objCCCMaster.BindBranchCode(ddlBranch);
objCommonClass.BindUnitSno(ddlProductDivison);
objCommonClass.BindDataGrid(gvComm, "uspMisDetail", true);
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Countries to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspBusinessAreaMaster", true, sqlParamSrh);
objBusinessAreaMaster.BindBusinessArea(ddlSBU);
imgBtnUpdate.Visible = false;
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Action to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspWSCFeedbackType", true, sqlParamSrh);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "WSCFeedback_Desc";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvComm, "[uspProductMaster]", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "ProductSegment_Desc";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Unit to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspUnitMaster", true, sqlParamSrh);
objCommonClass.BindCompany(ddlCompany);
objCommonClass.BindUnitType(ddlUnitType);
objCommonClass.BindCountry(ddlCountry);
imgBtnUpdate.Visible = false;
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
objCommonClass.BindRegion(ddlRegion);
//objCCCMaster.BindBranchCode(ddlBranch);
objCommonClass.BindUnitSno(ddlProductDivison);
objCommonClass.BindDataGrid(gvComm, "uspMisDetail", true, sqlParamSrh, lblRowCount);
ViewState["Column"] = "Complaint_RefNo";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling CCC to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "[uspCCCMaster]", true, sqlParamSrh, lblRowCount);
objCCCMaster.BindBranchCode(ddlBranchName);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "CCC_Code";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
public void BindGridOnDdlStatusChange(GridView gv)
{
SqlParameter[] param =
{
new SqlParameter("@Type", "SELECT_SERVICE_COMPLAINT"),
new SqlParameter("@SC_SNo", this.SC_SNo),
new SqlParameter("@CallStatus", this.CallStatus),
new SqlParameter("@MessageOut", SqlDbType.NVarChar, 1000)
};
param[3].Direction = ParameterDirection.Output;
objCommonClass.BindDataGrid(gv, "uspBaseComDet", true, param);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Year to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspYearMaster", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "PERIODYEAR_CODE";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Countries to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspCountryMaster", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Country_Code";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
#region Common
if (User.IsInRole("CGAdmin"))
{
sqlParamSrh[3].Value = "CGAdmin";
}
else if (User.IsInRole("CCAdmin"))
{
sqlParamSrh[3].Value = "CCAdmin";
}
else if (User.IsInRole("Super Admin"))
{
sqlParamSrh[3].Value = "Super Admin";
}
else
{
sqlParamSrh[3].Value = "";
}
sqlParamSrh[1].Value = ddlSearch.SelectedValue.ToString();
sqlParamSrh[2].Value = txtSearch.Text.Trim();
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
#endregion Common
if (!Page.IsPostBack)
{
//Filling Action to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspRoleMaster", true, sqlParamSrh, lblRowCount);
if (User.IsInRole("CGAdmin"))
{
objCommonClass.BindUserType(ddlUserType, "CGAdmin");
}
else if (User.IsInRole("CCAdmin"))
{
objCommonClass.BindUserType(ddlUserType, "CCAdmin");
}
else if (User.IsInRole("Super Admin"))
{
objCommonClass.BindUserType(ddlUserType, "Super Admin");
}
else
{
objCommonClass.BindUserType(ddlUserType, "");
}
imgBtnUpdate.Visible = false;
ViewState["Column"] = "RoleName";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
lblMessage.Text = "";
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvComm, "uspCategoryMaster", true, sqlParamSrh, lblRowCount);
objBusinessLine.BindBusinessLineddl(ddlBusinessLine);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Category_ID";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Question to grid of calling BindDataGrid of CommonClass
ddlQuestionType.Items.Insert(0, new ListItem("Select Type", "select"));
objCommonClass.BindDataGrid(gvComm, "[uspQuestionMaster]", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Question";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
private void SearchData()
{
try
{
if (gvComm.PageIndex != -1)
{
gvComm.PageIndex = 0;
}
sqlParamSrh[1].Value = int.Parse(ddlRegion.SelectedValue.ToString());
sqlParamSrh[2].Value = int.Parse(ddlBranch.SelectedValue.ToString());
//cose by Find Value CheckList Box
string strAllProductDiv = "";
for (int intCnt = 0; intCnt < checkLProductDivision.Items.Count; intCnt++)
{
if (checkLProductDivision.Items[intCnt].Selected == true)
{
string strProductDiv = checkLProductDivision.Items[intCnt].Value;
strAllProductDiv = strAllProductDiv + strProductDiv + ",";
}
}
strAllProductDiv = strAllProductDiv.TrimEnd(',');
sqlParamSrh[3].Value = strAllProductDiv;
//End
sqlParamSrh[4].Value = int.Parse(ddlSerContractor.SelectedValue.ToString());
lblMessage.Text = "";
objCommonClass.BindDataGrid(gvComm, "uspMisSCTerritoryDivision", true, sqlParamSrh, lblRowCount);
if (gvComm.Rows.Count > 0)
{
btnExportToExcel.Visible = true;
}
else
{
btnExportToExcel.Visible = false;
}
}
catch (Exception ex)
{
//Writing Error message to File using CommonClass WriteErrorErrFile method taking arguments as URL of page
// trace, error message
CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString());
}
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Countries to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspCityBranchMapping", true, sqlParamSrh, lblRowCount);
objCityBranchMapping.EmpCode = Membership.GetUser().UserName.ToString();
objCityBranchMapping.BindRegion(ddlRegionDesc);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Region_Desc";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
private void BindData(string strOrder)
{
try
{
sqlParamSrh[1].Value = int.Parse(ddlProductDiv.SelectedValue.ToString());
//sqlParamSrh[2].Value = txtTelephoneNo.Text.Trim();
sqlParamSrh[3].Value = txtProductSerialNo.Text.Trim();
DataSet dstData = new DataSet();
dstData = objCommonClass.BindDataGrid(gvComm, "uspMisLast6Months", true, sqlParamSrh, true);
lblRowCount.Text = dstData.Tables[0].Rows.Count.ToString();
DataView dvSource = default(DataView);
dvSource = dstData.Tables[0].DefaultView;
dvSource.Sort = strOrder;
if ((dstData != null))
{
gvComm.DataSource = dvSource;
gvComm.DataBind();
}
dstData = null;
dvSource.Dispose();
dvSource = null;
}
catch (Exception ex) { CommonClass.WriteErrorErrFile(Request.RawUrl.ToString(), ex.StackTrace.ToString() + "-->" + ex.Message.ToString()); }
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Countries to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspSIMSBranchMaster", true, sqlParamSrh, lblRowCount);
objSIMSBranchMaster.BindRegionCode(ddlRegionDesc);
ddlState.Items.Insert(0, new ListItem("Select", "Select"));
ddlCity.Items.Insert(0, new ListItem("Select", "Select"));
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Branch_Code";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Unit to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspUnitMaster", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
objUnitMaster.BindSBUDdl(ddlCompany);
//Code added by Naveen for MTO on 06/11/2009
objBusinessLine.BindBusinessLineddl(ddlBusinessLine);
// End Here
ViewState["Column"] = "Unit_Code";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
public DataSet BindData(GridView grv)
{
SqlParameter[] sqlParamSrh =
{
new SqlParameter("@Type", "SELECT"),
new SqlParameter("@Region_Sno", this.Region_Sno),
new SqlParameter("@Branch_Sno", this.Branch_SNo),
new SqlParameter("@Unit_SNo", this.Unit_SNo),
new SqlParameter("@FromDate", this.FromDate),
new SqlParameter("@ToDate", this.ToDate),
new SqlParameter("@StatusID", this.StatusID),
new SqlParameter("@Spare_Status", this.Spare_Status),
new SqlParameter("@UserName", Membership.GetUser().UserName.ToString())
};
dstData = objCommonClass.BindDataGrid(grv, "uspSpareTransMIS", true, sqlParamSrh, true);
return(dstData);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
//Filling Dealer to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "[uspDealerMaster]", true, sqlParamSrh);
imgBtnUpdate.Visible = false;
objCommonClass.BindCountry(ddlCountryCode);
objCommonClass.BindRegion(ddlRegion);
ddlCityCode.Items.Insert(0, "Select");
ddlStateCode.Items.Insert(0, "Select");
ddlBranch.Items.Insert(0, "Select");
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling CallStatus to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspCallStatusMaster", true, sqlParamSrh, lblRowCount);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "CallStage";
ViewState["Order"] = "ASC";
// Added by Gaurav Garg 20 OCT 09 for MTO
objBusinessLine.BindBusinessLineddl(ddlBusinessLine);
//END
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[4].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
//Filling Defect to grid of calling BindDataGrid of CommonClass
objCommonClass.BindDataGrid(gvComm, "uspBladeVendorMaster", true, sqlParamSrh, lblRowCount);
// Added by Gaurav Garg 20 OCT 09 for MTO
objBusinessLine.BindBusinessLineddl(ddlBusinessLine);
ddlProductDiv.Items.Insert(0, new ListItem("Select", "0"));
ddlProductLine.Items.Insert(0, new ListItem("Select", "0"));
ddldefect.Items.Insert(0, new ListItem("Select", "Select"));
ddlDC.Items.Insert(0, new ListItem("Select", "Select"));
imgBtnUpdate.Visible = false;
ViewState["Column"] = "Ident_Sno";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
protected void Page_Load(object sender, EventArgs e)
{
sqlParamSrh[3].Value = int.Parse(rdoboth.SelectedValue);
if (!Page.IsPostBack)
{
objCommonClass.BindDataGrid(gvComm, "uspOrgMaster", true, sqlParamSrh, lblRowCount);
objOrganizationMaster.BindUerID(ddlUserID);
objOrganizationMaster.BindRegion(ddlRegionDesc);
ddlBranchName.Items.Insert(0, new ListItem("Select", "Select"));
objBusinessLine.BindBusinessLineddl(ddlBusinessLine);
ddlProductDivision.Items.Insert(0, new ListItem("Select", "Select"));
objOrganizationMaster.BindRoleInDataList(rptUsersRoleList);
imgBtnUpdate.Visible = false;
ViewState["Column"] = "UserID";
ViewState["Order"] = "ASC";
}
System.Threading.Thread.Sleep(int.Parse(ConfigurationManager.AppSettings["AjaxPleaseWaitTime"]));
}
