public static DataTable updateUser([FromBody] createUser updateUser)
{
try
{
string ConnectionString = Common.GetConnectionString();
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@userId", updateUser.userId));
parameters.Add(new SqlParameter("@firstName", updateUser.firstName));
parameters.Add(new SqlParameter("@lastName", updateUser.lastName));
parameters.Add(new SqlParameter("@phoneNumber", updateUser.phoneNumber));
parameters.Add(new SqlParameter("@profileImage", updateUser.profileImage));
parameters.Add(new SqlParameter("@gender", updateUser.gender));
parameters.Add(new SqlParameter("@role", updateUser.role));
parameters.Add(new SqlParameter("@latitude", updateUser.latitude));
parameters.Add(new SqlParameter("@longitude", updateUser.longitude));
parameters.Add(new SqlParameter("@country", updateUser.country));
parameters.Add(new SqlParameter("@state", updateUser.state));
parameters.Add(new SqlParameter("@cityName", updateUser.cityName));
parameters.Add(new SqlParameter("@address", updateUser.address));
parameters.Add(new SqlParameter("@action", ""));
parameters.Add(new SqlParameter("@password", ""));
using (DataTable dt = SqlHelper.ExecuteDataset(ConnectionString, CommandType.StoredProcedure, "spsaveuser", parameters.ToArray()).Tables[0])
{
return(dt);
}
}
catch (Exception e)
{
throw e;
}
}
//public static string createUser(string firstName, string lastName, string email, string gender, string dob, string profileImage, string phoneNumber, string password, int countryId, int stateId, string city, string address, string pinCode, bool isEmailNotification, bool isSMSNotification, bool isPublicProfile, string userTypeId)//([FromBody]createUser userCreate)
//{
// try
// {
// string ConnectionString = Common.GetConnectionString();
// List<SqlParameter> parameters = new List<SqlParameter>();
// parameters.Add(new SqlParameter("@firstName", firstName));
// parameters.Add(new SqlParameter("@lastName", lastName));
// parameters.Add(new SqlParameter("@email", email));
// parameters.Add(new SqlParameter("@gender", gender));
// parameters.Add(new SqlParameter("@dob", Convert.ToDateTime(dob)));
// parameters.Add(new SqlParameter("@profileImage", profileImage));
// parameters.Add(new SqlParameter("@phoneNumber", phoneNumber));
// parameters.Add(new SqlParameter("@password", password));
// parameters.Add(new SqlParameter("@countryId", countryId));
// parameters.Add(new SqlParameter("@stateId", stateId));
// parameters.Add(new SqlParameter("@city", city));
// parameters.Add(new SqlParameter("@address", address));
// parameters.Add(new SqlParameter("@pinCode", pinCode));
// parameters.Add(new SqlParameter("@isEmailNotification", isEmailNotification));
// parameters.Add(new SqlParameter("@isSMSNotification", isSMSNotification));
// parameters.Add(new SqlParameter("@isPublicProfile", isPublicProfile));
// parameters.Add(new SqlParameter("@userTypeId", userTypeId));
// string rowsAffected = SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, "spCreateUser", parameters.ToArray()).ToString();
// return rowsAffected;
// }
// catch (Exception e)
// {
// throw e;
// }
//}
public static string createUser([FromBody] createUser userCreate)
{
try
{
string ConnectionString = Common.GetConnectionString();
var encryptPassword = Common.EncryptData(userCreate.password);
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.Add(new SqlParameter("@firstName", userCreate.firstName));
parameters.Add(new SqlParameter("@lastName", userCreate.lastName));
parameters.Add(new SqlParameter("@email", userCreate.email));
parameters.Add(new SqlParameter("@gender", userCreate.gender));
parameters.Add(new SqlParameter("@dob", Convert.ToDateTime(userCreate.dob)));
parameters.Add(new SqlParameter("@profileImage", userCreate.profileImage));
parameters.Add(new SqlParameter("@phoneNumber", userCreate.phoneNumber));
parameters.Add(new SqlParameter("@password", encryptPassword));
parameters.Add(new SqlParameter("@countryId", userCreate.countryId));
parameters.Add(new SqlParameter("@stateId", userCreate.stateId));
parameters.Add(new SqlParameter("@city", userCreate.city));
parameters.Add(new SqlParameter("@address", userCreate.address));
parameters.Add(new SqlParameter("@pinCode", userCreate.pinCode));
parameters.Add(new SqlParameter("@isEmailNotification", userCreate.isEmailNotification));
parameters.Add(new SqlParameter("@isSMSNotification", userCreate.isSMSNotification));
parameters.Add(new SqlParameter("@isPublicProfile", userCreate.isPublicProfile));
parameters.Add(new SqlParameter("@userTypeId", userCreate.userTypeId));
string rowsAffected = SqlHelper.ExecuteScalar(ConnectionString, CommandType.StoredProcedure, "spCreateUser", parameters.ToArray()).ToString();
return(rowsAffected);
}
catch (Exception e)
{
throw e;
}
}
public bool CreateUser(createUser createUser)
{
SqlCommand cmd = new SqlCommand();
sqlConnection obj_con = new sqlConnection();
int noOfRows = 0;
if (obj_con.con.State == ConnectionState.Closed)
{
obj_con.con.Open();
}
try
{
cmd.CommandText = "sign_up_insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Connection = obj_con.con;
cmd.Parameters.AddWithValue("@firstName", createUser.firstName);
cmd.Parameters.AddWithValue("@lastName", createUser.lastName);
cmd.Parameters.AddWithValue("@password", Utility.Encryptpassword(createUser.password));
cmd.Parameters.AddWithValue("@emailId", createUser.emailId);
cmd.Parameters.AddWithValue("@phoneNo", createUser.phoneNo);
cmd.Parameters.AddWithValue("@isAdmin", createUser.isAdmin == true?1:0);
noOfRows = cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
}
finally
{
cmd.Dispose();
obj_con.con.Close();
obj_con.con.Dispose();
}
return(noOfRows > 0 ? true : false);
}
public bool Post(createUser createUser)
{
if (ModelState.IsValid)
{
return(repository.CreateUser(createUser));
}
return(false);
}
public IActionResult createUser(createUser createUser)
{
try
{
if (createUser.firstName == "" || createUser.firstName == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter First Name" }));
}
else if (createUser.password == "" || createUser.password == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter Password" }));
}
else if (createUser.lastName == "" || createUser.lastName == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter lastName" }));
}
else if (createUser.phoneNumber == "" || createUser.phoneNumber == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter phonenumber" }));
}
Regex regex = new Regex(@"^\-?\d+\.?\d*$");
System.Text.RegularExpressions.Match latitude = regex.Match(createUser.latitude);
System.Text.RegularExpressions.Match longitude = regex.Match(createUser.latitude);
if (latitude.Success & longitude.Success)
{
DataTable dt = Data.User.createUser(createUser);
string Response = dt.Rows[0][0].ToString();
if (Response == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "Saved Successfully"));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Invalid latitude/longitude" }));
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("createUser", e.Message);
if (e.Message.Contains("UQ__tblUser__4849DA012EFB7F6C")) // Check Duplicate Key for PhoneNumber
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone Number is already exist" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
public IActionResult updateUser([FromBody] createUser updateUser)
{
try
{
Regex regex = new Regex(@"^\-?\d+\.?\d*$");
if (updateUser.userId <= 0 | updateUser.userId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter userId" }));
}
if (!String.IsNullOrEmpty(updateUser.latitude))
{
System.Text.RegularExpressions.Match latitude = regex.Match(updateUser.latitude);
if (latitude.Success != true)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter valid latitude" }));
}
}
if (!String.IsNullOrEmpty(updateUser.longitude))
{
System.Text.RegularExpressions.Match longitude = regex.Match(updateUser.latitude);
if (longitude.Success != true)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { ErrorMessage = "Please enter valid longitude" }));
}
}
DataTable dt = Data.User.updateUser(updateUser);
string Response = dt.Rows[0][0].ToString();
if (Response == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "Updated Successfully"));
}
else
{
if (Response.Contains("UQ__tblUser__4849DA012EFB7F6C") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone Number is already exist" }));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { ErrorMessage = Response }));
}
}
}
catch (Exception e)
{
string SaveErrorLog = Data.Common.SaveErrorLog("updateUser", e.Message);
if (e.Message.Contains("UQ__tblUser__4849DA012EFB7F6C") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = "Phone Number is already exist" }));
}
else
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { ErrorMessage = e.Message }));
}
}
}
// private static CommonPage _commonPage = UnityContainerFactory.GetContainer().Resolve<CommonPage>();
//example
public static IRestResponse CreateUser(string name, string job)
{
string queryBody;
createUser cus = new createUser();
cus.name = name;
cus.job = job;
queryBody = SimpleJson.SerializeObject(cus);
return(CommonAPICall.APICall(Method.POST, "api/users", queryBody));
}
public IActionResult Index(createUser user)
{
//var user = new User();
return(View(user));
}
public IActionResult createUser(createUser userCreate)
{
try
{
userCreate.profileImage = Global.fileurl;
List <createUser> userList = new List <createUser>();
if (userCreate.firstName == "" || userCreate.firstName == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter First Name" } }));
}
else if (userCreate.password == "" || userCreate.password == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Password" } }));
}
else if (userCreate.email == "" || userCreate.email == "string" || userCreate.email == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter Email" } }));
}
else if (userCreate.userTypeId == "" || userCreate.userTypeId == "string" || userCreate.userTypeId == null)
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter userTypeId" } }));
}
Regex regex = new Regex(@"^([\w\.\-]+)@([\w\-]+)((\.(\w){2,3})+)$");
Match match = regex.Match(userCreate.email);
if (match.Success)
{
string row = Data.User.createUser(userCreate);
if (row == "Success")
{
return(StatusCode((int)HttpStatusCode.OK, "Saved Successfully"));
}
else
{
if (row.Contains("UNIQUE KEY constraint") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Email Id is already exists" } }));
}
else
{
return(StatusCode((int)HttpStatusCode.Forbidden, new { error = new { message = row.ToString() } }));
}
}
}
else
{
return(StatusCode((int)HttpStatusCode.BadRequest, new { error = new { message = "Please enter a valid Email" } }));
}
}
catch (Exception e)
{
if (e.Message.Contains("UNIQUE KEY constraint") == true)
{
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = "Email Id is already exists" } }));
}
else
{
string SaveErrorLog = Data.Common.SaveErrorLog("createUser", e.Message);
return(StatusCode((int)HttpStatusCode.InternalServerError, new { error = new { message = e.Message } }));
}
}
}
public IEnumerable <createUser> SaveData([FromBody] createUser createuser)
{
int IsActive = 0;
string dtSponsorbankcode = "<dtXml>";
string dtCategorycode = "<dtXml>";
string dtUtilitycode = "<dtXml>";
string dtClientcode = "<dtXml>";
string dtSecBranch = "<dtXml>";
if (createuser.chkactive == true)
{
IsActive = 1;
}
else
{
IsActive = 0;
}
for (var i = 0; i < createuser.sponsorcodearr.Count; i++)
{
dtSponsorbankcode += "<dtXml ";
dtSponsorbankcode += " SponsorBankCodeId=" + @"""" + createuser.sponsorcodearr[i] + @"""";
dtSponsorbankcode += " />";
}
dtSponsorbankcode += "</dtXml>";
for (var i = 0; i < createuser.categorycodearr.Count; i++)
{
dtCategorycode += "<dtXml ";
dtCategorycode += " CategoryCode=" + @"""" + createuser.categorycodearr[i] + @"""";
dtCategorycode += " />";
}
dtCategorycode += "</dtXml>";
for (var i = 0; i < createuser.utilitycodearr.Count; i++)
{
dtUtilitycode += "<dtXml ";
dtUtilitycode += " UtilityCodeId=" + @"""" + createuser.utilitycodearr[i] + @"""";
dtUtilitycode += " />";
}
dtUtilitycode += "</dtXml>";
for (var i = 0; i < createuser.clientcodearr.Count; i++)
{
dtClientcode += "<dtXml ";
dtClientcode += " ClientId=" + @"""" + createuser.clientcodearr[i] + @"""";
dtClientcode += " />";
}
dtClientcode += "</dtXml>";
for (var i = 0; i < createuser.secbrancharr.Count; i++)
{
dtSecBranch += "<dtXml ";
dtSecBranch += " BranchId=" + @"""" + createuser.secbrancharr[i] + @"""";
dtSecBranch += " />";
}
dtSecBranch += "</dtXml>";
return(obj.SaveData(createuser, dtSponsorbankcode, dtCategorycode, dtUtilitycode, dtClientcode, dtSecBranch, IsActive, createuser.UserId, createuser.EntityId, createuser.AppId));
}
