public ActionResult GetprofileView(Tbl_Customer_Master TcM)
{
string Uid = Session["U_ID"].ToString();
DataAccessLayer objDB = new DataAccessLayer();
string result = objDB.CompleteProfile(TcM, Uid);
//rp.Showall = objDB.LoginDetail(Uobject);
return(View("test"));
}
//public List<RoleDesc> LoginDetail(Tbl_UserMaster Uobject)
//{
// //List<RoleDesc> sessionrole = new List<RoleDesc>();
// int sessionrole = 0;
// con = Utility.Util.Connection("DBEntities");
// string result = "";
// string result2 = "";
// string pageName = "Login";
// try
// {
// #region CheckLogin
// SqlCommand cmd = new SqlCommand("SP_Login", con);
// con.Open();
// cmd.CommandType = CommandType.StoredProcedure;
// cmd.Parameters.AddWithValue("@userName", Uobject.UserName);
// cmd.Parameters.AddWithValue("@Password", Uobject.Password);
// cmd.Parameters.AddWithValue("@Msg", "");
// result = cmd.ExecuteScalar().ToString();
// string[] lines = result.Split('-');
// int authvalue = lines[0].Contains("Login Successfull") ? 1 : 0;
// int id = Convert.ToInt16(lines[1]);
// #endregion
// #region insert into audit procedure
// result2 = AuditData.AduitFile.FillAudit(pageName, Uobject.UserName, authvalue);
// #endregion
// if (authvalue != 0)
// {
// getId = lines[1];
// getName = Uobject.UserName;
// sessionrole = Selectrole(id);
// return sessionrole;
// }
// else
// {
// //List<RoleDesc> errorlog = new List<RoleDesc>();
// RoleDesc rp = new RoleDesc();
// rp.id = 0;
// sessionrole.Add(rp);
// //return errorlog;
// }
// }
// catch (Exception ex)
// {
// ex.Message.ToString();
// return sessionrole;
// }
// finally
// {
// con.Close();
// }
// return sessionrole;
//}
#endregion
public string CompleteProfile(Tbl_Customer_Master tcm, string Uid)
{
con = Utility.Util.Connection("DBEntities");
string result = "";
String orgType = "";
string pageName = "Profile";
try
{
SqlCommand cmd = new SqlCommand("SP_CreateProfile", con);
con.Open();
if (tcm.OrganisationName == null)
{
orgType = "I";
}
else
{
orgType = "O";
}
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", Uid);
cmd.Parameters.AddWithValue("@First_Name", tcm.FirstName);
cmd.Parameters.AddWithValue("@Last_Name", tcm.LastName);
cmd.Parameters.AddWithValue("@Gender", tcm.Gender);
cmd.Parameters.AddWithValue("@DOB", tcm.DOB);
cmd.Parameters.AddWithValue("@PAN", tcm.PAN);
cmd.Parameters.AddWithValue("@DrivingLicenseNo", tcm.DrivingLicenseNo);
cmd.Parameters.AddWithValue("@IdProofeNumber", tcm.IDProofeNumber);
cmd.Parameters.AddWithValue("@Address", tcm.Address);
cmd.Parameters.AddWithValue("@Password", tcm.Password);
cmd.Parameters.AddWithValue("@Dist", tcm.Dist);
cmd.Parameters.AddWithValue("@State", tcm.State);
cmd.Parameters.AddWithValue("@Country", tcm.Country);
cmd.Parameters.AddWithValue("@Land_lineNo", tcm.LandlineNo);
cmd.Parameters.AddWithValue("@OtherGovID", tcm.OtherGovID);
cmd.Parameters.AddWithValue("@CINNo", tcm.CINNo);
cmd.Parameters.AddWithValue("@GISTNo", tcm.GISTNo);
cmd.Parameters.AddWithValue("@IsActive", tcm.IsActive);
cmd.Parameters.AddWithValue("@IDProofe", tcm.IDProofe);
cmd.Parameters.AddWithValue("@Nationality", tcm.Nationality);
cmd.Parameters.AddWithValue("@OrganisationName", tcm.OrganisationName);
cmd.Parameters.AddWithValue("@OrganisationType", orgType);
cmd.Parameters.AddWithValue("@AutherizedPerson", tcm.AutherizedPerson);
cmd.Parameters.AddWithValue("@AutherizPrsDesig", tcm.AutherizPrsDesig);
cmd.Parameters.AddWithValue("@AutherizPrsEmail_Id", tcm.AutherizPrsEmail_Id);
//cmd.Parameters.AddWithValue("@AutherizPrsMobile_No", "");
cmd.Parameters.AddWithValue("@city", tcm.City);
cmd.Parameters.AddWithValue("@Pincode", tcm.Pincode);
result = cmd.ExecuteNonQuery().ToString();
//int authvalue = result == "Register Successfully" ? 1 : 0;
//#region insert into audit procedure
//result2 = AuditData.AduitFile.FillAudit(pageName, Urobject.UserName, authvalue);
//#endregion
}
catch (Exception ex)
{
ex.Message.ToString();
return(result);
}
finally
{
con.Close();
}
return(result);
}
