public ActionResult Login(LoginViewModel model, string returnUrl)
{
try
{
UserMasterEntity userMasterEntity = new UserMasterEntity();
ValidateUser_Result validateUserResult = userMasterEntity.ValidateUser(model.UserName, model.Password).FirstOrDefault();
if (validateUserResult != null)
{
Session["UserName"] = validateUserResult.FirstName + " " + validateUserResult.LastName;
Session["Role"] = validateUserResult.Role;
Session["UserId"] = validateUserResult.UserId;
if (!string.IsNullOrEmpty(returnUrl))
{
return(Redirect(returnUrl));
}
else
{
return(RedirectToAction("Dashboard", "Home"));
}
}
else
{
ModelState.AddModelError("", "Invalid username or password.");
return(View(model));
}
}
catch (Exception ex)
{
logger.Error("An error occured.", ex);
return(View(model));
}
}
public async Task <IActionResult> DeleteUser([FromRoute] int id)
{
var response = _ObjectResponse;
UserMasterEntity entityUser = new UserMasterEntity();
var token = (string)this.Request.Headers["Authorization"];
token = token.Replace("Bearer", "").Trim();
var loggedInUser = UserHelper.GetLoggedInUser(token);
entityUser.IsDeleted = true;
entityUser.UserId = id;
entityUser.DeletedBy = loggedInUser.UserId;
var _oUser = await _UserService.UpdateUser(entityUser);
if (_oUser != null)
{
response = _ObjectResponse.Create(_oUser, _messageService.GetString("Delete"));
//response.Success = true;
//response.NotificationType = "Success";
return(response.ToHttpResponse());
}
else
{
response = _ObjectResponse.Create(_oUser, _messageService.GetString("DeleteFailed"));
return(response.ToHttpResponse(404));
// return NotFound();
}
}
public Payment(UserMasterEntity userdetail)
{
InitializeComponent();
BarTextColor = Color.White;
BarBackgroundColor = Color.FromHex("#c8c7c8");
UserDetail = userdetail;
}
public List <UserMasterEntity> CheckLogin(string UserData)
{
try
{
UserMasterEntity U = JsonConvert.DeserializeObject <UserMasterEntity>(UserData);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_LoginUser";
cmd.CommandType = CommandType.StoredProcedure;
//U.Password=ServiceUtility.Encrypt(U.Password); Security
cmd.Parameters.AddWithValue("@UserName", U.fldUserName);
U.fldPassword = Encrypt(U.fldPassword);
cmd.Parameters.AddWithValue("@Password", U.fldPassword);
//cmd.Parameters.AddWithValue("@UserType", U.UserType);
List <UserMasterEntity> lstUser = ConvertDataSetToList(SqlHelper.ExecuteDataset(cmd));
//
//if (lstUser.Count() >= 0)
//{
// U.fldUserID = lstUser[0].fldUserID;
// string UserDatatt = JsonConvert.SerializeObject(U);
// //AddLog(UserDatatt);
//}
return(lstUser);
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult ResetPassword(ManageUserViewModel manageUserViewModel)
{
UserMasterEntity userMasterEntity = new UserMasterEntity();
UserMaster userMaster = userMasterEntity.GetusermasterByEmailAddress(manageUserViewModel.EmailAddress);
userMaster.Password = manageUserViewModel.NewPassword;
userMaster.Token = "random";
userMasterEntity.Save(userMaster);
return(RedirectToAction("Login", "Account", new { id = "PasswordReset" }));
}
public HomePageViewModel()
{
APIHelper helper = new APIHelper();
home = helper.GetHomePage(101, 1, 1);
astrologers = new ObservableCollection <AstrologerEntity>(home.astrologersList);
userdetail = home.UserDetail;
System.Globalization.RegionInfo objRegInfo = new System.Globalization.RegionInfo("en-IN");
string syb = objRegInfo.CurrencySymbol;
rupee = syb;
LoadShoppingList();
}
public static DbStatusEntity[] InsertData(UserMasterEntity obj)
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new UserMasterDAO().InsertUserMaster(obj));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
public static DbStatusEntity[] UpdateData(UserMasterEntity obj, int id) //Update data in database
{
var details = new List <DbStatusEntity>();
try
{
details.Add(new UserMasterDAO().UpdateUserMaster(obj, id));
}
catch (Exception ex)
{
details.Clear();
details.Add(new DbStatusEntity(ex.Message));
}
return(details.ToArray());
}
public JsonResult ForgotPassword(string EmailId)
{
try
{
UserMasterEntity userMasterEntity = new UserMasterEntity();
UserMaster userMaster = userMasterEntity.GetusermasterByEmailAddress(EmailId);
if (userMaster != null)
{
if (userMaster.RoleId == 2)
{
TeacherMaster teacherMaster = new TeacherMasterEntity().GetTeacherByEmailAddress(EmailId);
userMaster.Token = Guid.NewGuid().ToString();
userMasterEntity.Save(userMaster);
var callbackUrl = "<a href='" + Url.Action("ResetPassword", "Account", new { email = userMaster.EmailAddress, code = userMaster.Token }, "http") + "'>Reset Password</a>";
MailMessage mail = new MailMessage();
mail.To.Add(userMaster.EmailAddress);
mail.From = new MailAddress(ConfigurationManager.AppSettings["SMTP_UserName"]);
string body = this.ForgotPassword(teacherMaster.FirstName, teacherMaster.LastName, callbackUrl);
mail.Subject = "Password reset link.";
mail.Body = body;
mail.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = ConfigurationManager.AppSettings["SMTP_Host"];
smtp.Port = Convert.ToInt16(ConfigurationManager.AppSettings["SMTP_Port"]);
smtp.UseDefaultCredentials = false;
smtp.Credentials = new System.Net.NetworkCredential(ConfigurationManager.AppSettings["SMTP_UserName"], ConfigurationManager.AppSettings["SMTP_Password"]); // Enter seders User name and password
smtp.EnableSsl = true;
smtp.Send(mail);
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(2, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
logger.Error("An error occured.", ex);
}
return(Json(JsonRequestBehavior.AllowGet));
}
public async Task <IActionResult> GetUserDetailById([FromRoute] int id)
{
var response = _ObjectResponse;
var OUser = new UserMasterEntity();
OUser = await _UserService.GetUserById(id);
if (OUser != null)
{
response = _ObjectResponse.Create(OUser, _messageService.GetString("GetById"));
return(response.ToHttpResponse());
}
else
{
response = _ObjectResponse.Create(OUser, _messageService.GetString("GetById"));
return(response.ToHttpResponse(404));
}
}
public async Task <IActionResult> SaveUpdateUser([FromBody] UserMasterEntity oUser)
{
var response = _ObjectResponse;
var _oUser = new UserMasterEntity();
var token = (string)this.Request.Headers["Authorization"];
token = token.Replace("Bearer", "").Trim();
var loggedInUser = UserHelper.GetLoggedInUser(token);
// Start : Added by Prasad for avoid duplication
var IsExist = _UserService.IsUserExist(oUser);
if (IsExist)
{
response = _ObjectResponse.Create(oUser, _messageService.GetString("Exist"));
return(response.ToHttpResponseConflict());
}
// End : Added by Prasad for avoid duplication
if (oUser.UserId == 0)
{
// oUser.CreatedBy = loggedInUser.UserId;
_oUser = await _UserService.AddUser(oUser);
response = _ObjectResponse.Create(_oUser, _messageService.GetString("Save"));
}
else
{
//oUser.UpdatedBy = loggedInUser.UserId;
_oUser = await _UserService.UpdateUser(oUser);
response = _ObjectResponse.Create(_oUser, _messageService.GetString("Update"));
}
//if (response != null)
// return response.ToHttpResponse();
//else if (_oUser != null)
// return Ok(_oUser);
//else
// return BadRequest();
return(response.ToHttpResponse());
}
public ActionResult ResetPassword(string email, string code)
{
ManageUserViewModel manageUserViewModel = new ManageUserViewModel();
UserMasterEntity userMasterEntity = new UserMasterEntity();
UserMaster userMaster = userMasterEntity.IsTokenExist(email, code);
if (userMaster != null)
{
manageUserViewModel.EmailAddress = email;
return(View(manageUserViewModel));
}
else
{
LoginViewModel loginViewModel = new LoginViewModel();
loginViewModel.toasterObject.Message = "Password reset link is not valid.";
return(View("Login", loginViewModel));
//return RedirectToAction("Login", "Account");
}
}
public ApiResponse <UserMasterEntity> UpdateUserMaster(UserMasterEntity modal)
{
var response = new ApiResponse <UserMasterEntity>();
try
{
// Get the uploaded image from the Files collection
//var httpPostedFile = System.Web.HttpContext.Current.Request.Files[0];
//byte[] data;
//using (System.IO.Stream inputStream = httpPostedFile.InputStream)
//{
// System.IO.MemoryStream memoryStream = inputStream as System.IO.MemoryStream;
// if (memoryStream == null)
// {
// memoryStream = new System.IO.MemoryStream();
// inputStream.CopyTo(memoryStream);
// }
// data = memoryStream.ToArray();
//}
SqlParameter[] param = { new SqlParameter("UserAccessID", (object)modal.UserAccessId ?? (object)DBNull.Value)
, new SqlParameter("FirstName", (object)modal.FirstName ?? (object)DBNull.Value)
, new SqlParameter("LastName", (object)modal.LastName ?? (object)DBNull.Value)
// , new SqlParameter("Photo", (object)data ?? (object)DBNull.Value)
};
var result = _repository.ExecuteSQL <UserMasterEntity>("UpdateUserMaster", param).ToList();
if (result == null)
{
result = new List <UserMasterEntity>();
}
response.Success = true;
response.Data = result;
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public List <UserMasterEntity> EditUserMaster(int id)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlDataAdapter adapter;
DataSet ds = new DataSet();
List <UserMasterEntity> retlst = new List <UserMasterEntity>();
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_GetUserDetailsbyID", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@ID", id);
con.Open();
adapter = new SqlDataAdapter(cmd);
adapter.Fill(ds);
for (int i = 0; i <= ds.Tables[0].Rows.Count - 1; i++)
{
UserMasterEntity obj = new UserMasterEntity();
obj.USER_ID = Convert.ToInt32(ds.Tables[0].Rows[i]["USER_ID"].ToString());
obj.EMAIL = ds.Tables[0].Rows[i]["EMAIL"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["EMAIL"].ToString();
obj.NAME = ds.Tables[0].Rows[i]["NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["NAME"].ToString();
obj.USER_PASSWORD = ds.Tables[0].Rows[i]["USER_PASSWORD"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["USER_PASSWORD"].ToString();
obj.ROLE_ID = ds.Tables[0].Rows[i]["ROLE_ID"] == DBNull.Value ? 0 : Convert.ToInt32(ds.Tables[0].Rows[i]["ROLE_ID"].ToString());
obj.ROLE_NAME = ds.Tables[0].Rows[i]["ROLE_NAME"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["ROLE_NAME"].ToString();
obj.MOBILE_NO = ds.Tables[0].Rows[i]["MOBILE_NO"] == DBNull.Value ? "" : ds.Tables[0].Rows[i]["MOBILE_NO"].ToString();
obj.ACTIVE_STATUS = ds.Tables[0].Rows[i]["ACTIVE_STATUS"] == DBNull.Value ? true : Convert.ToBoolean(ds.Tables[0].Rows[i]["ACTIVE_STATUS"]);
obj.USER_PASSWORD = CryptographyHelper.Instance.Decrypt(obj.USER_PASSWORD);
retlst.Add(obj);
}
}
}
catch (Exception ex)
{
throw ex;
}
return(retlst);
}
//public static string AddPatientDuringRegistration(string UserEntity)
//{
// UserMasterEntity USerMasterJson = JsonConvert.DeserializeObject<UserMasterEntity>(UserEntity);
// SqlCommand cmd = new SqlCommand();
// cmd.CommandText = "sp_tbPatientMasterAddDuringRegistration";
// cmd.CommandType = CommandType.StoredProcedure;
// _mainConnectionS = SqlHelper.GetConnection();
// _mainConnectionS.Open();
// cmd.Connection = _mainConnectionS;
// try
// {
// //@UniqueNumber nvarchar(50),@FullName nvarchar(50),@ConsultDoctorIDF int,@TreatmentPhaseIDF int,@TreatmentIDF int,@BloodGroupIDF int,
// //@Gender tinyint,@DateOfBirth smalldatetime,@MaritalStatus tinyint,@Mobile nvarchar(50),@Email nvarchar(50),@Address nvarchar(MAX),
// //@Description nvarchar(1000),@IsAllocated bit,@PatientPhotoURL nvarchar(MAX),@Height nvarchar(50),@Weight nvarchar(50),@Glucose nvarchar(50),@systolic nvarchar(50),
// //@Diastolic nvarchar(50),@Worktype nvarchar(50),@Diet nvarchar(MAX),@Alcoholconsumption nvarchar(MAX),@Breakfast nvarchar(MAX),@Lunch nvarchar(MAX),@Snacks nvarchar(MAX),
// cmd.Parameters.Add(new SqlParameter("@UniqueNumber", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, ""));
// cmd.Parameters.Add(new SqlParameter("@FullName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.RefName));
// cmd.Parameters.Add(new SqlParameter("@Gender", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.Gender));
// cmd.Parameters.Add(new SqlParameter("@Mobile", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.ContactNumber));
// cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.Address));
// cmd.Parameters.Add(new SqlParameter("@EntryDateTime", SqlDbType.DateTime, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntryDatetime));
// cmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.Int, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntrybyIDF));
// cmd.Parameters.Add(new SqlParameter("@ReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0));
// // Execute query.
// int j = cmd.ExecuteNonQuery();
// int returnID = Common.ConvertDBNullToInt32(cmd.Parameters["@ReturnID"].Value.ToString());
// return returnID.ToString();// +":" + returnID.ToString();
// }
// catch (Exception ex)
// {
// return "Create User::Insert::Error occured. Error message:" + ex.Message;
// }
// finally
// {
// cmd.Dispose();
// }
//}
public string AddLog(string UserEntity)
{
UserMasterEntity USerMasterJson = JsonConvert.DeserializeObject <UserMasterEntity>(UserEntity);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_AddLog_Insert";
cmd.CommandType = CommandType.StoredProcedure;
_mainConnection = SqlHelper.GetConnection();
_mainConnection.Open();
cmd.Connection = _mainConnection;
try
{
//UserIDF,MACAddress,ComputerName,LogInTime,BrowserName,LogOffTime
//cmd.Parameters.Add(new SqlParameter("@UserIDF", SqlDbType.Int, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.UserIDP));
//cmd.Parameters.Add(new SqlParameter("@MACAddress", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.MacAddress));
//cmd.Parameters.Add(new SqlParameter("@ComputerName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.ComputerName));
//cmd.Parameters.Add(new SqlParameter("@LogInTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntryDatetime));
//cmd.Parameters.Add(new SqlParameter("@LogOffTime", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntryDatetime));
//cmd.Parameters.Add(new SqlParameter("@BrowserName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.BrowserName));
cmd.Parameters.Add(new SqlParameter("@ReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0));
// Execute query.
int j = cmd.ExecuteNonQuery();
int returnID = Common.ConvertDBNullToInt32(cmd.Parameters["@ReturnID"].Value.ToString());
return(j.ToString() + ":" + returnID.ToString());
}
catch (Exception ex)
{
return("Create User::Insert::Error occured. Error message:" + ex.Message);
}
finally
{
cmd.Dispose();
}
}
private static List <UserMasterEntity> ConvertDataSetToList(DataSet ds)
{
if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
{
return(new List <UserMasterEntity>());
}
List <UserMasterEntity> lstUsers = new List <UserMasterEntity>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
UserMasterEntity U = new UserMasterEntity();
try
{
if (dr.Table.Columns.Contains("fldUserID"))
{
U.fldUserID = Convert.ToInt32(dr["fldUserID"]);
}
if (dr.Table.Columns.Contains("fldUserName"))
{
U.fldUserName = Convert.ToString(dr["fldUserName"]);
}
if (dr.Table.Columns.Contains("fldPassword"))
{
U.fldPassword = Convert.ToString(dr["fldPassword"]);
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
lstUsers.Add(U);
}
}
return(lstUsers);
}
public DbStatusEntity UpdateUserMaster(UserMasterEntity obj, int id)
{
DbStatusEntity objreturn = new DbStatusEntity();
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
try
{
using (SqlConnection con = new SqlConnection(CS))
{
SqlCommand cmd = new SqlCommand("USP_UpdateUsersMaster", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@USER_ID", id);
cmd.Parameters.AddWithValue("@USER_PASSWORD", CryptographyHelper.Instance.Encrypt(obj.USER_PASSWORD));
cmd.Parameters.AddWithValue("@NAME", obj.NAME);
cmd.Parameters.AddWithValue("@EMAIL", obj.EMAIL);
cmd.Parameters.AddWithValue("@MOBILE_NO", obj.MOBILE_NO);
cmd.Parameters.AddWithValue("@ACTIVE_STATUS", obj.ACTIVE_STATUS);
cmd.Parameters.AddWithValue("@ROLE_ID", obj.ROLE_ID);
cmd.Parameters.Add("@RESULT", SqlDbType.Int);
cmd.Parameters["@RESULT"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@CNT", SqlDbType.Int);
cmd.Parameters["@CNT"].Direction = ParameterDirection.Output;
cmd.Parameters.Add("@MSG", SqlDbType.NVarChar, 500);
cmd.Parameters["@MSG"].Direction = ParameterDirection.Output;
con.Open();
cmd.ExecuteNonQuery();
objreturn.RESULT = Convert.ToInt32(cmd.Parameters["@RESULT"].Value);
objreturn.CNT = Convert.ToInt32(cmd.Parameters["@CNT"].Value);
objreturn.MSG = Convert.ToString(cmd.Parameters["@MSG"].Value);
con.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(objreturn);
}
public string UpdateUser(string UserEntity)
{
//sdsd shubham
UserMasterEntity UserMasterJson = JsonConvert.DeserializeObject <UserMasterEntity>(UserEntity);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_User_Update";
cmd.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
_mainConnection = SqlHelper.GetConnection();
_mainConnection.Open();
cmd.Connection = _mainConnection;
try
{
//cmd.Parameters.Add(new SqlParameter("@UserIDP", SqlDbType.Int, 4, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, UserMasterJson.UserIDP));
//cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, UserMasterJson.Password));
cmd.Parameters.Add(new SqlParameter("@ReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0));
// Execute query.
int j = cmd.ExecuteNonQuery();
int returnID = Common.ConvertDBNullToInt32(cmd.Parameters["@ReturnID"].Value.ToString());
return(returnID.ToString() + ":" + j.ToString());
}
catch (Exception ex)
{
return("UpdateUser::Update::Error occured. Error message:" + ex.Message);
}
finally
{
cmd.Dispose();
}
}
public ApiResponse <UserMasterEntity> UserMasterUpdatePassword(UserMasterEntity modal)
{
var response = new ApiResponse <UserMasterEntity>();
try
{
SqlParameter[] param = { new SqlParameter("UserAccessID", (object)modal.UserAccessId ?? (object)DBNull.Value)
, new SqlParameter("Password", (object)Security.Encrypt(modal.Password) ?? (object)DBNull.Value) };
var result = _repository.ExecuteSQL <UserMasterEntity>("UserMasterUpdatePassword", param).ToList();
if (result == null)
{
result = new List <UserMasterEntity>();
}
response.Success = true;
response.Data = result;
}
catch (Exception ex)
{
response.Message.Add(ex.Message);
}
return(response);
}
public string CreateUser(string UserEntity)
{
UserMasterEntity USerMasterJson = JsonConvert.DeserializeObject <UserMasterEntity>(UserEntity);
SqlCommand cmd = new SqlCommand();
cmd.CommandText = "sp_User_Insert";
cmd.CommandType = CommandType.StoredProcedure;
// Use base class' connection object
_mainConnection = SqlHelper.GetConnection();
_mainConnection.Open();
cmd.Connection = _mainConnection;
try
{
//try
//{
// var id = AddPatientDuringRegistration(JsonConvert.SerializeObject(USerMasterJson));
// USerMasterJson.ReferanceIDF = Convert.ToInt32(id);
//}
//catch
//{
// USerMasterJson.ReferanceIDF = null;
//}
USerMasterJson.fldPassword = Encrypt(USerMasterJson.fldPassword);
//@RefName@Password@Gender@ContactNumber@UserType@AddressEntryDateTime@EntryByIsDelete
//cmd.Parameters.Add(new SqlParameter("@UserName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.UserName));
//cmd.Parameters.Add(new SqlParameter("@RefName", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.RefName));
//cmd.Parameters.Add(new SqlParameter("@Password", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.Password));
//cmd.Parameters.Add(new SqlParameter("@Gender", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.Gender));
//cmd.Parameters.Add(new SqlParameter("@ContactNumber", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.ContactNumber));
//cmd.Parameters.Add(new SqlParameter("@ReferanceIDF", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.ReferanceIDF));
//cmd.Parameters.Add(new SqlParameter("@UserType", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.UserType));
//cmd.Parameters.Add(new SqlParameter("@Address", SqlDbType.NVarChar, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.Address));
//cmd.Parameters.Add(new SqlParameter("@EntryDateTime", SqlDbType.DateTime, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntryDatetime));
//cmd.Parameters.Add(new SqlParameter("@EntryBy", SqlDbType.Int, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, USerMasterJson.EntrybyIDF));
cmd.Parameters.Add(new SqlParameter("@IsDelete", SqlDbType.Bit, 100, ParameterDirection.Input, false, 10, 0, "", DataRowVersion.Proposed, 0));
cmd.Parameters.Add(new SqlParameter("@ReturnID", SqlDbType.Int, 4, ParameterDirection.Output, false, 10, 0, "", DataRowVersion.Proposed, 0));
// Execute query.
int j = cmd.ExecuteNonQuery();
int returnID = Common.ConvertDBNullToInt32(cmd.Parameters["@ReturnID"].Value.ToString());
//try
//{
// return j.ToString() + ":" + returnID.ToString();
//}
//catch
//{
return(returnID.ToString() + ":" + j.ToString());
//}
}
catch (Exception ex)
{
return("Create User::Insert::Error occured. Error message:" + ex.Message);
}
finally
{
cmd.Dispose();
}
}
