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 GetUserAddressById(int intUserId)
{
try
{
ShippingAddressResponseModel _response = new ShippingAddressResponseModel();
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var command = dataContext.Database.Connection.CreateCommand();
command.CommandText = "usp_Shipping_Address";
command.CommandType = CommandType.StoredProcedure;
var p = new SqlParameter("@intUserid", intUserId);
var p1 = new SqlParameter("@strAddress", "");
var p2 = new SqlParameter("@intCityid", 0);
var p3 = new SqlParameter("@intStateid", 0);
var p4 = new SqlParameter("@intCountryId", 0);
var p5 = new SqlParameter("@strPin", "");
var p6 = new SqlParameter("@strMobileNo", "");
var p7 = new SqlParameter("@StrAction", "GetAllShippingAddress");
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);
command.Parameters.Add(p7);
var reader = command.ExecuteReader();
DataSet oDS = new DataSet();
while (!reader.IsClosed)
{
oDS.Tables.Add().Load(reader);
}
if (oDS.Tables[0].Rows.Count != 0)
{
_response.intShippingid = Convert.ToInt32(oDS.Tables[0].Rows[0]["ShippingId"]);
_response.strAddress = oDS.Tables[0].Rows[0]["v_address"].ToString();
_response.intCityId = Convert.ToInt32(oDS.Tables[0].Rows[0]["intCityId"]);
_response.strCity = oDS.Tables[0].Rows[0]["City"].ToString();
_response.intStateId = Convert.ToInt32(oDS.Tables[0].Rows[0]["intStateId"]);
_response.strState = oDS.Tables[0].Rows[0]["States"].ToString();
_response.intCountryId = Convert.ToInt32(oDS.Tables[0].Rows[0]["intCountryId"]);
_response.strCountry = oDS.Tables[0].Rows[0]["Country"].ToString();
_response.strPin = oDS.Tables[0].Rows[0]["v_pin"].ToString();
_response.strMobileNo = oDS.Tables[0].Rows[0]["v_mobile_no"].ToString();
}
dataContext.Database.Connection.Close();
}
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _response
});
}
catch (Exception ex)
{
throw;
}
}
public CityModel DeleteCity(int intCityId)
{
CityModel _objdata = new CityModel();
tbl_Cities _objCity = new tbl_Cities();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Cities.Where(x => x.int_Id == intCityId).FirstOrDefault();
if (_query != null)
{
tbl_Cities _log = new tbl_Cities();
_log = dataContext.tbl_Cities.Where(x => x.int_Id == intCityId).FirstOrDefault();
_log.b_flag = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "City deleted sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public List <ProductMaster> ProductMastersList(List <ProductMaster> _listproduct)
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
List <ProductMaster> _list = (from _product in dataContext.tbl_Products
join _category in dataContext.tbl_category on _product.int_CategoryId equals _category.int_id
join _brand in dataContext.tbl_Brands on _product.int_BrandsId equals _brand.int_id
where _product.b_IsActive == true
select new ProductMaster
{
intProductId = _product.int_id,
strBrand = _brand.v_name,
strCategory = _category.v_category,
strProductName = _product.v_name,
intStocks = (int)_product.int_quantity,
dblPrice = (double)_product.fl_price
}).ToList();
return(_list);
}
}
catch (Exception ex)
{
throw;
}
}
public object GetCountry()
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
List <CountryModel> _list = (from _country in dataContext.tbl_Countries
where _country.b_IsActive == true
select new CountryModel
{
intCountryId = _country.int_Id,
strCountryName = _country.v_country,
strCourncy = _country.v_currency,
strCourncySymbol = _country.v_currency_symbol
}).ToList();
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _list
});
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel DeleteState(int intStateId)
{
StateModel _objdata = new StateModel();
tbl_States _objState = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault();
if (_query != null)
{
tbl_States _log = new tbl_States();
_log = dataContext.tbl_States.Where(x => x.int_Id == intStateId).FirstOrDefault();
_log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "State deleted sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public ProductModal DeleteProduct(int intProductId)
{
ProductModal _objdata = new ProductModal();
tbl_Products _objproduct = new tbl_Products();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Products.Where(x => x.int_id == intProductId).FirstOrDefault();
if (_query != null)
{
tbl_Products _log = new tbl_Products();
_log = dataContext.tbl_Products.Where(x => x.int_id == intProductId).FirstOrDefault();
_log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Product updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public BrandModel DeleteBrand(int intBrandId)
{
BrandModel _objdata = new BrandModel();
tbl_Brands _objBrand = new tbl_Brands();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Brands.Where(x => x.int_id == intBrandId).FirstOrDefault();
if (_query != null)
{
tbl_Brands _log = new tbl_Brands();
_log = dataContext.tbl_Brands.Where(x => x.int_id == intBrandId).FirstOrDefault();
// _log.b_IsActive = false;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Brand deleted sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel SaveState(StateModel _objdata)
{
tbl_States _objState = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objState.v_State = _objdata.strStateName;
_objState.int_CountryId = _objdata.intCountryId;
_objState.dt_Created_On = DateTime.Now;
_objState.b_IsActive = true;
dataContext.tbl_States.Add(_objState);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "State save sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel UpdateState(StateModel _objdata)
{
tbl_States _objproduct = new tbl_States();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault();
if (_query != null)
{
tbl_States _log = new tbl_States();
_log = dataContext.tbl_States.Where(x => x.int_Id == _objdata.intStateId).FirstOrDefault();
_log.v_State = _objdata.strStateName;
_log.int_CountryId = _objdata.intCountryId;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "State Updated sucessfully.";
return(_objdata);
}
}
catch (Exception ex)
{
throw ex;
}
}
public CountryModel UpdateCountry(CountryModel _objdata)
{
tbl_Countries _objCountry = new tbl_Countries();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault();
if (_query != null)
{
tbl_Countries _objTemp = new tbl_Countries();
_objTemp = dataContext.tbl_Countries.Where(x => x.int_Id == _objdata.intCountryId).FirstOrDefault();
_objTemp.v_country = _objdata.strCountryName;
_objTemp.v_currency = _objdata.strCourncy;
_objTemp.v_currency_symbol = _objdata.strCourncySymbol;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Country updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public CategoryModel UpdateCategory(CategoryModel _objdata)
{
tbl_category _objcategory = new tbl_category();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_category.Where(x => x.int_id == _objdata.intCategoryId).FirstOrDefault();
if (_query != null)
{
tbl_category _log = new tbl_category();
_log = dataContext.tbl_category.Where(x => x.int_id == _objdata.intCategoryId).FirstOrDefault();
_log.v_category = _objdata.strCategoryName;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Category updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public CountryModel SaveCountry(CountryModel _objdata)
{
tbl_Countries _objCountry = new tbl_Countries();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objCountry.v_country = _objdata.strCountryName;
_objCountry.v_currency = _objdata.strCourncy;
_objCountry.v_currency_symbol = _objdata.strCourncySymbol;
_objCountry.b_IsActive = true;
dataContext.tbl_Countries.Add(_objCountry);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "Country save sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public UserModel SaveUser(UserModel _objdata)
{
tbl_All_User _objuser = new tbl_All_User();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objuser.int_id = (int)_objdata.int_id;
_objuser.int_User_Type = _objdata.intModuleTypeId;
_objuser.v_FirstName = _objdata.strFirstName;
_objuser.v_LastName = _objdata.strLastName;
_objuser.v_EmailId = _objdata.strEmailId;
_objuser.v_MobileNo = _objdata.strMobileNo;
_objuser.int_CountryId = _objdata.intCityId;
_objuser.int_StateId = _objdata.intStateId;
_objuser.int_CityId = _objdata.intCityId;
_objuser.v_address = _objdata.strAddress;
_objuser.v_Password = _objdata.strPassword;
_objuser.dt_CreatedOn = DateTime.Now;
_objuser.b_IsActive = true;
dataContext.tbl_All_User.Add(_objuser);
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
_objdata.StatusMessaage = "User save sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
public object GetUserById(int intUserId)
{
try
{
UserModel _usermodal = new UserModel();
using (newconecommerce dataContext = new newconecommerce())
{
_usermodal = (from x in dataContext.tbl_All_User
where x.int_id == intUserId
select new UserModel
{
intModuleTypeId = (int)x.int_User_Type,
int_id = x.int_id,
strFirstName = x.v_FirstName,
strLastName = x.v_LastName,
strEmailId = x.v_EmailId,
strMobileNo = x.v_MobileNo,
intCountryId = (int)x.int_CountryId,
intCityId = (int)x.int_CityId,
intStateId = (int)x.int_StateId,
strAddress = x.v_address,
strPin = x.v_Pin,
strPassword = x.v_Password
}).FirstOrDefault();
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _usermodal
});
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <CityModel> CityMastersList(List <CityModel> _listCity)
{
try
{
using (newconecommerce dataContext = new newconecommerce())
{
List <CityModel> _list = (from _City in dataContext.tbl_Cities
join _states in dataContext.tbl_States on _City.int_Id equals _states.int_Id
join _country in dataContext.tbl_Countries on _states.int_CountryId equals _country.int_Id
where _country.b_IsActive == true && _City.b_flag == true
select new CityModel
{
intCityId = _City.int_Id,
strCityName = _City.v_City,
intStateId = _states.int_Id,
strStateName = _states.v_State,
intCountryId = _country.int_Id,
strCountryName = _country.v_country
}).ToList();
return(_list);
}
}
catch (Exception ex)
{
throw;
}
}
public BrandModel UpdateBrand(BrandModel _objdata)
{
tbl_Brands _objBrand = new tbl_Brands();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
var _query = dataContext.tbl_Brands.Where(x => x.int_id == _objdata.intBrandId).FirstOrDefault();
if (_query != null)
{
tbl_Brands _log = new tbl_Brands();
_log = dataContext.tbl_Brands.Where(x => x.int_id == _objdata.intBrandId).FirstOrDefault();
_log.v_name = _objdata.strBrandName;
dataContext.SaveChanges();
dataContext.Database.Connection.Close();
}
_objdata.StatusMessaage = "Brand updated sucessfully.";
return(_objdata);
}
}
catch (Exception)
{
throw;
}
}
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 CheckLogin(UserModel _login)
//{
// tbl_All_User log = new tbl_All_User();
// try
// {
// using (newconecommerce dataContext = new newconecommerce())
// {
// dataContext.Database.Connection.Open();
// var query = dataContext.tbl_All_User.Where(a => a.v_EmailId == _login.strEmailId || a.v_MobileNo == _login.strEmailId && a.v_Password == _login.strPassword).FirstOrDefault();
// var querye = dataContext.tbl_All_User.Where(a => a.v_EmailId == _login.strEmailId || a.v_MobileNo == _login.strMobileNo).FirstOrDefault();
// var _checkAlreadyLogin = (object)null;
// if (query!=null)
// _checkAlreadyLogin = (from x in dataContext.tbl_OTP
// where x.int_user_id == query.int_id && x.dt_logout_time == null
// select x.int_user_id).FirstOrDefault();
// if (querye != null)
// {
// if (query == null)
// {
// return new ResponseModel { StatusCode = (int)CCommon.StatusCode.UnAuthorizedAccess, StatusMessaage = "Email id and password do not match.", data = log };
// }
// else if (_checkAlreadyLogin != null)
// {
// return new ResponseModel { StatusCode = (int)CCommon.StatusCode.Fail, StatusMessaage = CCommon.StatusCode.Fail.ToString(), data = "Already logged in with other device." };
// }
// else
// {
// Random generator = new Random();
// string number = generator.Next(1, 10000).ToString("D4");
// string strMessage = "Your OTP for Just Cool App is :" + number + ". Regards Just Cool.com";
// tbl_OTP _objLoginInput = new tbl_OTP();
// _objLoginInput.int_moduleType_id = _login.intModuleTypeId;
// _objLoginInput.int_user_id = _login.int_id;
// _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();
// }
// log = query;
// return new ResponseModel { StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = log };
// }
// else
// {
// return new ResponseModel { StatusCode = (int)CCommon.StatusCode.InvalidMailId, StatusMessaage = "Could not find email id in our system.", data = log };
// }
// }
// }
// 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 = log };
// }
//}
public object CheckLogin(UserModel _login)
{
try
{
Postloginres _log = new Postloginres();
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();
_log.strMsg = oDS.Tables[0].Rows[0]["Msg"].ToString();
dataContext.Database.Connection.Close();
}
dataContext.Database.Connection.Close();
}
return(new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = _log
});
}
catch (Exception ex)
{
throw;
}
}
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 object UserSignUp(UserModel _objdata)
{
tbl_All_User _objuser = new tbl_All_User();
try
{
using (newconecommerce dataContext = new newconecommerce())
{
dataContext.Database.Connection.Open();
_objuser.int_id = (int)_objdata.int_id;
_objuser.int_User_Type = _objdata.intModuleTypeId;
_objuser.v_FirstName = _objdata.strFirstName;
_objuser.v_LastName = _objdata.strLastName;
_objuser.v_EmailId = _objdata.strEmailId;
_objuser.v_MobileNo = _objdata.strMobileNo;
_objuser.int_CountryId = _objdata.intCountryId;
_objuser.int_StateId = _objdata.intStateId;
_objuser.int_CityId = _objdata.intCityId;
_objuser.v_address = _objdata.strAddress;
_objuser.v_Pin = _objdata.strPin;
_objuser.v_Password = _objdata.strPassword;
_objuser.dt_CreatedOn = DateTime.Now;
_objuser.b_IsActive = true;
dataContext.tbl_All_User.Add(_objuser);
dataContext.SaveChanges();
UserModel _model = new UserModel();
_model.intUserId = _objuser.int_id;
dataContext.Database.Connection.Close();
if (_model.intUserId != 0)
{
return new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = "User save sucessfully."
}
}
;
else
{
return new ResponseModel {
StatusCode = (int)CCommon.StatusCode.Success, StatusMessaage = CCommon.StatusCode.Success.ToString(), data = "something went wrong"
}
};
}
}
catch (Exception ex)
{
throw ex;
}
}
public StateModel GetStateById(StateModel _statemodal)
{
StateModel _objstate = new StateModel();
using (newconecommerce dataContext = new newconecommerce())
{
_objstate = (from x in dataContext.tbl_States
where x.int_Id == _statemodal.intStateId
select new StateModel
{
strStateName = x.v_State,
intCountryId = (int)x.int_CountryId
}).FirstOrDefault();
return(_objstate);
}
}
public List <UserTypeList> GetUserTypeList()
{
using (newconecommerce dataContext = new newconecommerce())
{
List <UserTypeList> _listUserType = new List <UserTypeList>();
dataContext.Database.Connection.Open();
_listUserType = (from _usertype in dataContext.tbl_User_Types.AsEnumerable()
select new UserTypeList
{
int_id = _usertype.int_Id,
v_User_Type = _usertype.v_name
}).ToList();
_listUserType.Insert(0, new UserTypeList {
v_User_Type = "--Select User Type--", int_id = 0
});
return(_listUserType);
}
}
public List <ProductCategory> GetCategory()
{
using (newconecommerce dataContext = new newconecommerce())
{
List <ProductCategory> _listCategory = new List <ProductCategory>();
dataContext.Database.Connection.Open();
_listCategory = (from _category in dataContext.tbl_category.AsEnumerable()
select new ProductCategory
{
int_id = _category.int_id,
strCategory = _category.v_category
}).ToList();
_listCategory.Insert(0, new ProductCategory {
strCategory = "--Select Category--", int_id = 0
});
return(_listCategory);
}
}
public List <StateModel> GetState()
{
using (newconecommerce dataContext = new newconecommerce())
{
List <StateModel> _listState = new List <StateModel>();
dataContext.Database.Connection.Open();
_listState = (from _state in dataContext.tbl_States.AsEnumerable()
select new StateModel
{
intStateId = _state.int_Id,
strStateName = _state.v_State
}).ToList();
_listState.Insert(0, new StateModel {
strStateName = "--Select State--"
});
return(_listState);
}
}
public List <CountryModel> GetCountry()
{
using (newconecommerce dataContext = new newconecommerce())
{
List <CountryModel> _listCountry = new List <CountryModel>();
dataContext.Database.Connection.Open();
_listCountry = (from _country in dataContext.tbl_Countries.AsEnumerable()
select new CountryModel
{
intCountryId = _country.int_Id,
strCountryName = _country.v_country
}).ToList();
_listCountry.Insert(0, new CountryModel {
strCountryName = "--Select Country--"
});
return(_listCountry);
}
}
public List <ProductBrands> GetBrands()
{
using (newconecommerce dataContext = new newconecommerce())
{
List <ProductBrands> _listBrand = new List <ProductBrands>();
dataContext.Database.Connection.Open();
_listBrand = (from _brand in dataContext.tbl_Brands.AsEnumerable()
select new ProductBrands
{
int_id = _brand.int_id,
strBrands = _brand.v_name
}).ToList();
_listBrand.Insert(0, new ProductBrands {
strBrands = "--Select Brand--", int_id = 0
});
return(_listBrand);
}
}
public CategoryModel GetCategoryById(CategoryModel _categorymodal)
{
CategoryModel _objcategory = new CategoryModel();
using (newconecommerce dataContext = new newconecommerce())
{
_objcategory = (from x in dataContext.tbl_category
where x.int_id == _categorymodal.intCategoryId
select new CategoryModel
{
strCategoryName = x.v_category
}).AsEnumerable().Select(x => new CategoryModel
{
strCategoryName = x.strCategoryName
}).FirstOrDefault();
return(_objcategory);
}
}
public BrandModel GetBrandById(BrandModel _Brandmodal)
{
BrandModel _objBrand = new BrandModel();
using (newconecommerce dataContext = new newconecommerce())
{
_objBrand = (from x in dataContext.tbl_Brands
where x.int_id == _Brandmodal.intBrandId
select new BrandModel
{
strBrandName = x.v_name
}).AsEnumerable().Select(x => new BrandModel
{
strBrandName = x.strBrandName
}).FirstOrDefault();
return(_objBrand);
}
}
