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