private void BindControlVal(int customerEnqId)
{
CustomerEnquiry ObjBE = new CustomerEnquiry();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("@CommandText", "GetEnqById");
dic.Add("@CustomerEnquiryId", customerEnqId);
ProcParametersBe proc = new ProcParametersBe();
proc.storedProcName = "SP_CustomerEnquiry";
proc.objDictionary = dic;
DataSet Ds = CommonDAL.GetResultDAL(proc);
if (Ds != null)
{
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
{
txtCustName.Text = Convert.ToString(Ds.Tables[0].Rows[i]["CustomerName"]);
txtPartName.Text = Ds.Tables[0].Rows[i]["PartName"].ToString();
txtEnqNo.Text = Ds.Tables[0].Rows[i]["EnquiryNo"].ToString();
txtCustDrawing.Text = Ds.Tables[0].Rows[i]["CustomerDrawingPartNo"].ToString();
txtFmsiNo.Text = Ds.Tables[0].Rows[i]["FMSINo"].ToString();
txtWvaNo.Text = Ds.Tables[0].Rows[i]["WVANo"].ToString();
txtModelName.Text = Ds.Tables[0].Rows[i]["VehicleModelName"].ToString();
txtModelStartYr.Text = Ds.Tables[0].Rows[i]["VehicleModelStartYear"].ToString();
txtDwgRevNo.Text = Ds.Tables[0].Rows[i]["DWGRevisionNo"].ToString();
txtEnqRecDt.Text = Ds.Tables[0].Rows[i]["EnquiryRecievedDate"].ToString();
txtAnnualVol.Text = Ds.Tables[0].Rows[i]["AnnualVolume"].ToString();
///txtCreatedOn.Text = Ds.Tables[0].Rows[i]["CreatedOn"].ToString();
}
btnSave.Enabled = false;
}
else
{
btnSave.Enabled = true;
}
}
//protected void btnnew_Click(object sender, EventArgs e)
//{
// Response.Redirect("~/About.aspx");
//}
//protected void btnPswd_Click(object sender, EventArgs e)
//{
// Response.Redirect("~/PasswordForgot.aspx");
//}
private UserAccount GetUserInfo(string UserName, string Password)
{
UserAccount userAcc = new UserAccount();
Dictionary <string, object> dic = new Dictionary <string, object>();
dic.Add("@CommandText", "CheckUserCredentials");
dic.Add("@UserName", UserName);
dic.Add("@Password", Password);
ProcParametersBe proc = new ProcParametersBe();
proc.storedProcName = "SP_User";
proc.objDictionary = dic;
DataSet ds = CommonDAL.GetResultDAL(proc);
if (ds != null)
{
if (ds.Tables.Count > 0 && ds.Tables[0] != null)
{
if (ds.Tables[0].Rows.Count > 0)
{
//isExist = true;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
userAcc.UserId = Convert.ToInt32(ds.Tables[0].Rows[i]["UserId"]);
userAcc.UserName = ds.Tables[0].Rows[i]["UserName"].ToString();
userAcc.FirstName = ds.Tables[0].Rows[i]["FirstName"].ToString();
userAcc.LastName = ds.Tables[0].Rows[i]["LastName"].ToString();
userAcc.ProfilePic = ds.Tables[0].Rows[i]["ProfilePic"].ToString();
}
}
}
}
return(userAcc);
//using (SqlConnection con = new SqlConnection(connStr))
//{
// SqlCommand cmd;
// if (con.State == ConnectionState.Open)
// {
// con.Close();
// }
// cmd = new SqlCommand();
// //cmd.CommandText = "insert into Tbl_User(FirstName,LastName,EmailId,PhoneNo,ProfilePic,BackupPhone)values('" + usrAcc.FirstName + "','" + usrAcc.LastName + "','" + usrAcc.Email + "','" + usrAcc.Phone + "','" + usrAcc.FilePath + "','" + usrAcc.BackupPhone + "')";
// //cmd.CommandText = "insert into Tbl_User(ColUserName,ColFirstName,ColLastName,ColEmailId,ColPhoneNo,ColProfilePic,ColPassword,ColRePassword,ColSecurity,ColGender,ColPhone,ColBackupPhone,ColRecoveryId)values('" + usrAcc.UserName + "','" + usrAcc.FirstName + "','" + usrAcc.LastName + "','" + usrAcc.Email + "','" + usrAcc.Phone + "','" + usrAcc.FilePath + "','" + usrAcc.Password + "','" + usrAcc.RePassword + "','" + usrAcc.Security + "','" + usrAcc.Gender + "','" + usrAcc.Phone + "','" + usrAcc.BackupPhone + "','" + usrAcc.RecoveryId + "')";
// cmd.CommandText = "select * from Tbl_User where UserName='******' AND Password='******' ";
// con.Open();
// cmd.Connection = con;
// var dr = cmd.ExecuteReader();
// if (dr.HasRows)
// {
// isExist = true;
// }
// else
// {
// isExist = false;
// }
// con.Close();
// return isExist;
//}
}
public static DataSet GetResultDAL(ProcParametersBe objProcParametersBe)
{
DataSet ds = GetDataSet(objProcParametersBe);
return(ds);
}
