public DataSet UserInsertUpdate(JsonMember.UserDetails obj) { try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(8); Sqldbmanager.AddParameters(0, "@AUserId", obj.AUserId); Sqldbmanager.AddParameters(1, "@UserId", obj.UserId); Sqldbmanager.AddParameters(2, "@LoginId", obj.LoginId); Sqldbmanager.AddParameters(3, "@Name", obj.Name); Sqldbmanager.AddParameters(4, "@Password", obj.Password); Sqldbmanager.AddParameters(5, "@EmailId", obj.EmailId); Sqldbmanager.AddParameters(6, "@ContactNo", obj.ContactNo); Sqldbmanager.AddParameters(7, "@DepartmentId", obj.DepartmentId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UserInserUpdate"); } catch (Exception Ex) { DS = LogError("User Insert Update", Ex.Message.ToString(), "SP Name: USP_UserInserUpdate"); } finally { Sqldbmanager.Close(); } return(DS); }
public DataSet MenuPermission(JsonMember.UserDetails obj) { try { StringBuilder InMenuPermission = new StringBuilder(); for (int i = 0; i < obj.MenuPermission.Count; i++) { InMenuPermission.AppendLine("<nodes>"); InMenuPermission.AppendLine(" <node>"); InMenuPermission.AppendLine(" <MenuId>" + obj.MenuPermission[i].MenuId + "</MenuId>"); InMenuPermission.AppendLine(" <AdminType>" + obj.MenuPermission[i].AdminType + "</AdminType>"); InMenuPermission.AppendLine(" <CounterType>" + obj.MenuPermission[i].CounterType + "</CounterType>"); InMenuPermission.AppendLine(" </node>"); InMenuPermission.AppendLine("</nodes>"); } Sqldbmanager.Open(); Sqldbmanager.CreateParameters(2); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@InMenuPermission", InMenuPermission.ToString()); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_MeunPermission"); } catch (Exception Ex) { DS = LogError("MenuPermission", Ex.Message.ToString(), "SP Name: USP_MeunPermission"); } finally { Sqldbmanager.Close(); } return(DS); }
public DataTable UpdatePassword(JsonMember.UserDetails obj) { try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(2); Sqldbmanager.AddParameters(0, "@Flag", "getPassword"); Sqldbmanager.AddParameters(1, "@Id", obj.UserId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_CommonData"); if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password) { Sqldbmanager.CreateParameters(8); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@NewPassword", obj.NewPassword); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UpdatePassword"); dt = DS.Tables[0]; } else { dt = DS.Tables[1]; } } catch (Exception Ex) { DS = LogError("Update Password", Ex.Message.ToString(), "SP Name: USP_UpdatePassword"); } finally { Sqldbmanager.Close(); } return(dt); }
public object UpdatePersonalDetails(JsonMember.UserDetails obj) { LoginReturn Lobj = new LoginReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(5); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@FirstName", obj.FirstName.Trim()); Sqldbmanager.AddParameters(2, "@LastName", obj.LastName.Trim()); Sqldbmanager.AddParameters(3, "@EmailId", obj.EmailId.Trim()); Sqldbmanager.AddParameters(4, "@ProfilePicPath", obj.ProfilePicPath); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_UpdateuserProfile"); Lobj = new LoginReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), EmailId = DS.Tables[0].Rows[0]["EmailId"].ToString(), MobileNo = DS.Tables[0].Rows[0]["MobileNo"].ToString(), Name = DS.Tables[0].Rows[0]["Name"].ToString(), UserName = DS.Tables[0].Rows[0]["UserName"].ToString(), UserId = DS.Tables[0].Rows[0]["UserId"].ToString(), FirstName = DS.Tables[0].Rows[0]["FirstName"].ToString(), LastName = DS.Tables[0].Rows[0]["LastName"].ToString(), ProfilePicPath = DS.Tables[0].Rows[0]["ProfilePicPath"].ToString() }; } catch (Exception Ex) { DS = LogError("Update Personal Detail", Ex.Message.ToString(), "SP Name: USP_UpdateuserProfile"); Lobj = new LoginReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } finally { Sqldbmanager.Close(); } return(Lobj); }
public object GenerateUser(JsonMember.UserDetails obj) { registrationReturn obj1 = new registrationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(5); Sqldbmanager.AddParameters(0, "@Name", obj.Name); Sqldbmanager.AddParameters(1, "@UserName", obj.UserName); Sqldbmanager.AddParameters(2, "@UserPassword", obj.Password); Sqldbmanager.AddParameters(3, "@EmailId", obj.EmailId); Sqldbmanager.AddParameters(4, "@MobileNo", obj.MobileNo); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_GenerateUser"); if (Convert.ToBoolean(DS.Tables[0].Rows[0]["flag"]) == true) { objEMail.SendSMSbyTillio(obj.MobileNo, "Flipprr Verification Code " + DS.Tables[0].Rows[0]["OTP"].ToString()); //Thread thrdSms = new Thread(() => SmsResult = (new Email()).SendSMS(obj.MobileNo, DS.Tables[0].Rows[0]["OTP"].ToString() + " is your flipprr verification code.")); //thrdSms.Start(); //Thread thrdMail = new Thread(() => MailResult = (new Email()).sendMail(obj.EmailId, "", "Flipprr Verification Code", DS.Tables[0].Rows[0]["OTP"].ToString(), "")); //thrdMail.Start(); } obj1 = new registrationReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), OTPId = DS.Tables[0].Rows[0]["OTPId"].ToString(), OTP = DS.Tables[0].Rows[0]["OTP"].ToString(), UserId = DS.Tables[0].Rows[0]["UserId"].ToString() }; } catch (Exception Ex) { DS = LogError("Generate User", Ex.Message.ToString(), "SP Name: USP_GenerateUser"); obj1 = new registrationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), OTPId = "", OTP = "", UserId = "" }; } finally { Sqldbmanager.Close(); } return(obj1); }
public DataSet HeaderDetails(JsonMember.UserDetails obj) { try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_HeaderDetails"); } catch (Exception Ex) { DS = LogError("Header Details", Ex.Message.ToString(), "SP Name: USP_HeaderDetails"); } finally { Sqldbmanager.Close(); } return(DS); }
public object ForgetPassword(JsonMember.UserDetails obj) { registrationReturn obj1 = new registrationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "usp_ForgetPassword"); if (Convert.ToBoolean(DS.Tables[0].Rows[0]["flag"]) == true) { //objEMail.SendSMS(obj.MobileNo, DS.Tables[0].Rows[0]["MobileNo"].ToString() + " is your flipprr verification code."); objEMail.SendSMSbyTillio(DS.Tables[0].Rows[0]["MobileNo"].ToString(), "Flipprr Verification Code " + DS.Tables[0].Rows[0]["OTP"].ToString()); } obj1 = new registrationReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), OTPId = DS.Tables[0].Rows[0]["OTPId"].ToString(), OTP = DS.Tables[0].Rows[0]["OTP"].ToString(), UserId = DS.Tables[0].Rows[0]["UserId"].ToString() }; } catch (Exception Ex) { DS = LogError("Forget Password", Ex.Message.ToString(), "SP Name: usp_ForgetPassword"); obj1 = new registrationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), OTPId = "", OTP = "", UserId = "" }; } finally { Sqldbmanager.Close(); } return(obj1); }
public object ChangePassword(JsonMember.UserDetails obj) { registrationReturn obj1 = new registrationReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(4); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); Sqldbmanager.AddParameters(1, "@OTPId", obj.OTPId); Sqldbmanager.AddParameters(2, "@OTP", obj.OTP); Sqldbmanager.AddParameters(3, "@UserPassword", obj.Password); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_ChangePassword"); obj1 = new registrationReturn() { flag = DS.Tables[0].Rows[0]["flag"].ToString(), Message = DS.Tables[0].Rows[0]["Message"].ToString(), OTPId = "", OTP = "", UserId = DS.Tables[0].Rows[0]["UserId"].ToString() }; } catch (Exception Ex) { DS = LogError("Change Password", Ex.Message.ToString(), "SP Name: USP_ChangePassword"); obj1 = new registrationReturn() { flag = "false", Message = DS.Tables[0].Rows[0]["Meaasge"].ToString(), OTPId = "", OTP = "", UserId = "" }; } finally { Sqldbmanager.Close(); } return(obj1); }
public DataTable LoginMaster(JsonMember.UserDetails obj) { DataTable Logindt = new DataTable(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster"); if (DS.Tables[1].Rows.Count > 0) { if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password) { Logindt = DS.Tables[1]; } else { Logindt = LogError("LoginMaster", "Invaid Password", obj.LoginId).Tables[0]; } } else { Logindt = LogError("LoginMaster", "Invaid Login Id", obj.LoginId).Tables[0]; } } catch (Exception Ex) { Logindt = LogError("LoginMaster", Ex.Message.ToString(), "").Tables[0]; } finally { Sqldbmanager.Close(); } return(Logindt); }
public object GetAllProfileDetails(JsonMember.UserDetails obj) { List <JsonMember.LoginReturn> lstDetails = new List <JsonMember.LoginReturn>(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@UserId", obj.UserId); idr = Sqldbmanager.ExecuteReader(CommandType.StoredProcedure, "USP_GetCompletePoflieDetails"); if (idr.Read()) { while (idr.Read()) { lstDetails.Add(new JsonMember.LoginReturn() { flag = "true", Message = "Success", EmailId = Convert.ToString(idr["EmailId"]), MobileNo = Convert.ToString(idr["MobileNo"]), Name = Convert.ToString(idr["Name"]), UserName = Convert.ToString(idr["UserName"]), UserId = Convert.ToString(idr["UserId"]), FirstName = Convert.ToString(idr["FirstName"]), LastName = Convert.ToString(idr["LastName"]), ProfilePicPath = Convert.ToString(idr["ProfilePicPath"]) }); } } else { lstDetails.Add(new JsonMember.LoginReturn() { flag = "false", Message = "No User Found", EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }); } } catch (Exception Ex) { lstDetails.Add(new JsonMember.LoginReturn() { flag = "false", Message = Ex.Message.ToString(), EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }); } finally { Sqldbmanager.Close(); } return(lstDetails); }
public Object LoginMaster(JsonMember.UserDetails obj) { LoginReturn Lobj = new LoginReturn(); DataTable Logindt = new DataTable(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster"); if (DS.Tables[1].Rows.Count > 0) { if (DS.Tables[0].Rows[0]["UserPassword"].ToString() == obj.Password) { Lobj = new LoginReturn() { flag = "true", Message = "Success", EmailId = DS.Tables[1].Rows[0]["EmailId"].ToString(), MobileNo = DS.Tables[1].Rows[0]["MobileNo"].ToString(), Name = DS.Tables[1].Rows[0]["Name"].ToString(), UserName = DS.Tables[1].Rows[0]["UserName"].ToString(), UserId = DS.Tables[1].Rows[0]["UserId"].ToString(), FirstName = DS.Tables[1].Rows[0]["FirstName"].ToString(), LastName = DS.Tables[1].Rows[0]["LastName"].ToString(), ProfilePicPath = DS.Tables[1].Rows[0]["ProfilePicPath"].ToString() }; } else { Lobj = new LoginReturn() { flag = "false", Message = "Invalid Password", EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } } else { Lobj = new LoginReturn() { flag = "false", Message = "User not register with us.", EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } } catch (Exception) { Lobj = new LoginReturn() { flag = "false", Message = "Invalid Email/Mobile", EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } finally { Sqldbmanager.Close(); } return(Lobj); }
public object GetProfileByLogin(JsonMember.UserDetails obj) { LoginReturn lstDetails = new LoginReturn(); try { Sqldbmanager.Open(); Sqldbmanager.CreateParameters(1); Sqldbmanager.AddParameters(0, "@LoginId", obj.LoginId); DS = Sqldbmanager.ExecuteDataSet(CommandType.StoredProcedure, "USP_LoginMaster"); if (DS.Tables[1].Rows.Count > 0) { lstDetails = new LoginReturn() { flag = "true", Message = "Success", EmailId = DS.Tables[1].Rows[0]["EmailId"].ToString(), MobileNo = DS.Tables[1].Rows[0]["MobileNo"].ToString(), Name = DS.Tables[1].Rows[0]["Name"].ToString(), UserName = DS.Tables[1].Rows[0]["UserName"].ToString(), UserId = DS.Tables[1].Rows[0]["UserId"].ToString(), FirstName = DS.Tables[1].Rows[0]["FirstName"].ToString(), LastName = DS.Tables[1].Rows[0]["LastName"].ToString(), ProfilePicPath = DS.Tables[1].Rows[0]["ProfilePicPath"].ToString() }; } else { lstDetails = new LoginReturn() { flag = "false", Message = "No User Found", EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } } catch (Exception Ex) { lstDetails = new LoginReturn() { flag = "false", Message = Ex.Message.ToString(), EmailId = "", MobileNo = "", Name = "", UserId = "", FirstName = "", LastName = "", ProfilePicPath = "", }; } finally { Sqldbmanager.Close(); } return(lstDetails); }