public object ForgotPassword(string email_id)
{
try
{
int isMailsend = 0;
var res = dataContext.tbl_All_User.Where(a => a.v_EmailId == email_id).FirstOrDefault();
if (res != null)
{
isMailsend = sentForgetPasswordEmail(res.v_EmailId, res.v_Password);
return(new ResponseModel {
StatusCode = isMailsend != 1 ? (int)CCommon.StatusCode.Fail : (int)CCommon.StatusCode.Success, StatusMessaage = isMailsend != 1 ? "Could not find email id in our system." : "Please check your email. The password has been sent there.", data = ""
});
}
else
{
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = "Could not find email id in our system.", data = ""
});
}
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = ""
});
}
}
public object PostLogout(Postloginreq _login)
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
tbl_OTP _logoutInput = dataContext.tbl_OTP.Single(e => e.int_user_id == _login.intloginId && e.dt_logout_time == null);
_logoutInput.dt_logout_time = DateTime.Now;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = ""
});
}
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = ""
});
}
}
public object ChangePassword(int UserId, string ChangePassword, int int_moduleType_id, string OldPassword)
{
try
{
var _userPswd = dataContext.tbl_All_User.Where(a => a.int_id == UserId && a.int_User_Type == int_moduleType_id).FirstOrDefault();
if (_userPswd != null)
{
if (_userPswd.v_Password != OldPassword)
{
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "Incorrect Old Password."
});
}
else
{
_userPswd.v_Password = ChangePassword;
}
}
int Result = dataContext.SaveChanges();
return(new ResponseModel {
StatusCode = Result != 0 ? (int)CCommon.StatusCode.Success : (int)CCommon.StatusCode.Notsaved, StatusMessaage = Result != 0 ? CCommon.StatusCode.Success.ToString() : CCommon.StatusCode.Notsaved.ToString(), data = ""
});
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = ""
});
}
}
public UserModel CheckLogin(LoginViewModel _login)
{
try
{
UserModel _log = new UserModel();
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var command = dataContext.Database.Connection.CreateCommand();
command.CommandText = "[usp_user_login]";
command.CommandType = CommandType.StoredProcedure;
var p = new SqlParameter("@v_EmailId", _login.strEmailId);
var p1 = new SqlParameter("@v_Password", _login.strPassword);
//var p2 = new SqlParameter("@v_MobileNo", _login.strMobileNo);
//var p3 = new SqlParameter("@intModuleTypeId", _login.intModuleTypeId);
//var p4 = new SqlParameter("@strDeviceId", _login.strDeviceId);
//var p5 = new SqlParameter("@strDevicetoken", _login.strDevicetoken);
//var p6 = new SqlParameter("@strDevicemode", _login.strDevicemode);
command.Parameters.Add(p);
command.Parameters.Add(p1);
//command.Parameters.Add(p2);
//command.Parameters.Add(p3);
//command.Parameters.Add(p4);
//command.Parameters.Add(p5);
//command.Parameters.Add(p6);
var reader = command.ExecuteReader();
DataSet oDS = new DataSet();
while (!reader.IsClosed)
{
oDS.Tables.Add().Load(reader);
}
if (oDS.Tables[0].Rows.Count != 0)
{
_log.intUserId = Convert.ToInt32(oDS.Tables[0].Rows[0]["int_id"]);
_log.strName = oDS.Tables[0].Rows[0]["strName"].ToString();
_log.strEmailId = oDS.Tables[0].Rows[0]["strEmailId"].ToString();
_log.strMobileNo = oDS.Tables[0].Rows[0]["strMobileNo"].ToString();
dataContext.Database.Connection.Close();
}
else
{
_log.StatusMessaage = oDS.Tables[0].Rows[0]["Msg"].ToString();
}
}
return(_log);
//return new ResponseModel { StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _log };
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
throw ex;
}
}
public object PostLogin(Postloginreq _login)
{
try
{
Random generator = new Random();
string number = generator.Next(1, 10000).ToString("D4");
string strMessage = "Your OTP for Just Cool App is :" + number + ". Regards Corvi.com";
using (newconecommerce dataContext = new newconecommerce())
{
var query = (from x in dataContext.tbl_OTP
where x.int_user_id == _login.intloginId && x.dt_logout_time == null
select x.int_user_id).FirstOrDefault();
if (query != null)
{
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "Already logged in with other device."
});
}
else
{
dataContext.Database.Connection.Open();
tbl_OTP _objLoginInput = new tbl_OTP();
_objLoginInput.int_moduleType_id = _login.intModuleTypeId;
_objLoginInput.int_user_id = _login.intloginId;
_objLoginInput.int_OTP = Convert.ToInt32(number);
_objLoginInput.dt_OTP_created = DateTime.Now;
_objLoginInput.dt_login_time = DateTime.Now;
_objLoginInput.v_device_id = _login.strDeviceId;
_objLoginInput.v_device_token = _login.strDevicetoken;
_objLoginInput.v_device_token = _login.strDevicemode;
_objLoginInput.dt_created_on = DateTime.Now;
dataContext.tbl_OTP.Add(_objLoginInput);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = "Login success"
});
}
}
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = "Failed to login."
});
}
}
public object getProductCartByUserId(AddToCartModel addtocart)
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
if (addtocart.int_user_id == 0)
{
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "Incorrect Retailer Id."
});
}
else
{
var result = dataContext.usp_get_user_cart_by_id(addtocart.int_user_id).ToList();
if (result.Count > 0)
{
if (result[0] != null)
{
MemoryStream memStream = new MemoryStream();
BinaryFormatter formatter = new BinaryFormatter();
memStream.Position = 0;
memStream = new MemoryStream();
byte[] strTemp = (byte[])result[0];
memStream.Write(strTemp, 0, strTemp.Length);
memStream.Seek(0, SeekOrigin.Begin);
Object obj = (Object)formatter.Deserialize(memStream);
addtocart.listProduct = (List <Product>)obj;
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = addtocart
});
}
}
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "No data Found."
});
}
}
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = "Failed to AddToCart."
});
}
}
public UserModel LoginUser(LoginViewModel _objLogin)
{
try
{
UserModel _login = new UserModel();
LoginUserDataAccess _objdataAccess = new LoginUserDataAccess();
_login = _objdataAccess.CheckLogin(_objLogin);
return(_login);
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
throw ex;
}
}
public object AddToCart(AddToCartModel addtocart)
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
if (addtocart.int_user_id == 0)
{
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "Incorrect Retailer Id."
});
}
else
{
MemoryStream memStream = new MemoryStream();
IFormatter formatter = new BinaryFormatter();
formatter.Serialize(memStream, addtocart.listProduct);
byte[] arrBytes = memStream.ToArray();
memStream.Write(arrBytes, 0, arrBytes.Length);
memStream.Seek(0, SeekOrigin.Begin);
test(memStream.GetBuffer());
dataContext.usp_insert_shopping_cart(addtocart.int_user_id, memStream.GetBuffer());
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = "Successfully Added to Cart"
});
}
}
}
catch (Exception ex)
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.ExceptionOccured, StatusMessaage = CCommon.StatusCode.ExceptionOccured.ToString(), data = "Failed to AddToCart."
});
}
}
public ActionResult Login(LoginViewModel model, string returnUrl)
{
try
{
if (!ModelState.IsValid)
{
return(View(model));
}
UserModel _objlogindetails = new UserModel();
LoginUserBAL _loginbal = new LoginUserBAL();
_objlogindetails = _loginbal.LoginUser(model);
if (_objlogindetails.StatusMessaage != null)
{
ModelState.AddModelError("", _objlogindetails.StatusMessaage);
return(View(model));
}
Session["strUserId"] = _objlogindetails.int_id;
Session["strUserName"] = _objlogindetails.strName;
Session["strEmailId"] = _objlogindetails.strEmailId;
Session["strMobileNo"] = _objlogindetails.strMobileNo;
return(RedirectToAction("Index", "DashBoard"));
}
catch (Exception ex)
{
if (ex.Message.Contains("That's not a valid username or password."))
{
ModelState.AddModelError("", "Invalid login attempt.");
return(View(model));
}
else
{
CMail.SendSystemGeneratedMailSync(CCommon.strAdminEmailID, "TRACKING-ERROR-MAIL", ex.ToString(), CCommon.strEmailFrom, true);
throw ex;
}
}
}
