protected void btnShowPulledRecord_Click(object sender, EventArgs e) { if (txtFromDate.Text == "" || txtTodate.Text == "") { ////COUNT ALL NOT PULLED RECORD SqlParameter sqlParamS = new SqlParameter("@Type", "COUNT_NOT_PULLED_RECORD_NOT_BASED_ON_DATE"); SqlDataReader objSqldr; objSqldr = objSql.ExecuteReader(CommandType.StoredProcedure, "uspPPR_TRANS", sqlParamS); if (objSqldr.Read()) { string strCount = objSqldr["TotalNotPulledRows"].ToString(); if (int.Parse(strCount) > 0) { lblStrMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.other, enuMessageType.UserMessage, true, "Total Number record's to pull-->" + strCount); btnExportExcel.Visible = true; btnExportExcel.Enabled = true; } else { btnExportExcel.Visible = false; btnExportExcel.Enabled = false; lblStrMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.other, enuMessageType.UserMessage, true, "No record found to pull"); } } } else { ////COUNT ALL NOT PULLED RECORD BETWEEN TWO DATE SqlParameter[] sqlParamS = { new SqlParameter("@Type", "COUNT_NOT_PULLED_RECORD"), new SqlParameter("@FromDate", txtFromDate.Text.Trim()), new SqlParameter("@TODate", txtTodate.Text.Trim()) }; SqlDataReader objSqldr; objSqldr = objSql.ExecuteReader(CommandType.StoredProcedure, "uspPPR_TRANS", sqlParamS); if (objSqldr.Read()) { string strCount = objSqldr["TotalNotPulledRows"].ToString(); if (int.Parse(strCount) > 0) { lblStrMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.other, enuMessageType.UserMessage, true, "Total Number record's to pull-->" + strCount); btnExportExcel.Visible = true; btnExportExcel.Enabled = true; } else { btnExportExcel.Visible = false; btnExportExcel.Enabled = false; lblStrMessage.Text = CommonClass.getErrorWarrning(enuErrorWarrning.other, enuMessageType.UserMessage, true, "No record found to pull"); } } } }
/// <summary> /// Get FHP Motor Defect based on complaint ref no /// </summary> /// <returns></returns> public List <string>[] GetServiceEnggDetailsOnSplitComplaintNo() { List <string>[] lstServiceEngg = new List <string> [2]; try { SqlParameter[] sqlParamI = { new SqlParameter("@SplitComplaintRefNo", this.SplitComplaintRefNo), new SqlParameter("@Type", "ServiceEnggDetails") }; SqlDataReader dr = objSql.ExecuteReader(CommandType.StoredProcedure, "GETFHPMoterDefectDetails", sqlParamI); while (dr.Read()) { //lstServiceEngg.Add(dr["ServiceEng_Name"].ToString(), dr["PhoneNo"].ToString()); lstServiceEngg[0] = new List <string>(); lstServiceEngg[1] = new List <string>(); lstServiceEngg[0].Add(Convert.ToString(dr["ServiceEng_Name"])); lstServiceEngg[1].Add(Convert.ToString(dr["PhoneNo"])); } sqlParamI = null; return(lstServiceEngg); } catch (Exception ex) { return(lstServiceEngg); } }
public void FillTextBox(TextBox txtBatchDesc) { SqlDataReader drFill; SqlParameter[] sqlParam = { new SqlParameter("@Type", "FILL_TEXTBOX"), new SqlParameter("@Batch_SNo", this.BatchSNo), new SqlParameter("@Batch_Desc", txtBatchDesc.Text) }; drFill = objSql.ExecuteReader(CommandType.StoredProcedure, "uspBatchMaster", sqlParam); if (drFill.Read()) { txtBatchDesc.Text = drFill["Batch_Desc"].ToString(); } }
public bool validateTvtUserId() { bool flag = true; SqlParameter[] sqlParamM = { new SqlParameter("@UserName", UserName), new SqlParameter("@Type", "TVTUSERVALIDATION"), new SqlParameter("@TvtUserId", this.TvtUserId) }; SqlDataReader dr = objSql.ExecuteReader(CommandType.StoredProcedure, "uspEditUserAndRoleMaster", sqlParamM); if (dr.Read()) { flag = string.IsNullOrEmpty(dr[0].ToString()) ? true:false; } return(flag); }