public long AddPerson(UserProfileObject user)
{
try
{
if (user == null)
{
return(-2);
}
var person = new Person
{
FirstName = user.PersonObject.FirstName,
LastName = user.PersonObject.LastName,
ImporterId = user.PersonObject.ImporterId
};
using (var db = new ImportPermitEntities())
{
var existings = db.People.Where(p => p.FirstName.ToLower().Trim() == user.PersonObject.FirstName.ToLower().Trim() && p.LastName.ToLower().Trim() == user.PersonObject.LastName.ToLower().Trim() && p.ImporterId == user.PersonObject.ImporterId).ToList();
if (existings.Any())
{
return(existings[0].Id);
}
var res = db.People.Add(person);
db.SaveChanges();
return(res.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public static void SaveUserProfile(UserProfileObject user)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_CST465"].ConnectionString))
{
SqlCommand command = new SqlCommand("UserProfile_InsertUpdate", connection);
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserId", user.UserID));
command.Parameters.Add(new SqlParameter("@FirstName", user.FirstName));
command.Parameters.Add(new SqlParameter("@LastName", user.LastName));
command.Parameters.Add(new SqlParameter("@Age", user.Age));
command.Parameters.Add(new SqlParameter("@PhoneNumber", user.PhoneNumber));
command.Parameters.Add(new SqlParameter("@EmailAddress", user.Email));
command.Parameters.Add(new SqlParameter("@StreetAddress", user.Address));
command.Parameters.Add(new SqlParameter("@City", user.City));
command.Parameters.Add(new SqlParameter("@State", user.State));
command.Parameters.Add(new SqlParameter("@ZipCode", user.ZipCode));
command.Parameters.Add(new SqlParameter("@ProfileImage", user.Image));
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
}
}
}
public static void SaveUserProfile(UserProfileObject user)
{
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_CST465"].ConnectionString))
{
SqlCommand command = new SqlCommand("UserProfile_InsertUpdate", connection);
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserId", user.UserID));
command.Parameters.Add(new SqlParameter("@FirstName", user.FirstName));
command.Parameters.Add(new SqlParameter("@LastName", user.LastName));
command.Parameters.Add(new SqlParameter("@Age", user.Age));
command.Parameters.Add(new SqlParameter("@PhoneNumber", user.PhoneNumber));
command.Parameters.Add(new SqlParameter("@EmailAddress", user.Email));
command.Parameters.Add(new SqlParameter("@StreetAddress", user.Address));
command.Parameters.Add(new SqlParameter("@City", user.City));
command.Parameters.Add(new SqlParameter("@State", user.State));
command.Parameters.Add(new SqlParameter("@ZipCode", user.ZipCode));
command.Parameters.Add(new SqlParameter("@ProfileImage", user.Image));
try
{
command.ExecuteNonQuery();
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
}
}
}
protected void uxSubmit_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
MembershipUser user = Membership.GetUser();
Guid userID = (Guid)user.ProviderUserKey;
UserProfileObject myprofile = new UserProfileObject();
myprofile.UserID = userID;
myprofile.FirstName = uxFirstName.Text;
myprofile.LastName = uxLastName.Text;
myprofile.Age = uxAge.Text;
myprofile.PhoneNumber = uxPhonenumber.Text;
myprofile.EmailAddress = uxEmailAddress.Text;
myprofile.ConfrimEmail = uxConfirmEmail.Text;
myprofile.StreetAddress = uxStreetAddress.Text;
myprofile.City = uxCity.Text;
myprofile.State = uxState.SelectedValue;
myprofile.Zip = uxZipcode.Text;
if (uxImageUpload.HasFile)
{
byte[] buffer = new byte[uxImageUpload.PostedFile.ContentLength];
uxImageUpload.PostedFile.InputStream.Read(buffer, 0, uxImageUpload.PostedFile.ContentLength);
myprofile.profileimage = buffer;
}
Session["ProfileData"] = myprofile;
UserProfileRepo.SaveUserProfile(myprofile);
MultiView1.ActiveViewIndex = 1;
}
}
public long UpdateImporterDepotAndPerson(UserProfileObject person)
{
try
{
if (person == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var existing = db.Importers.Where(i => i.Id == person.CompanyId).ToList();
if (!existing.Any())
{
return(-2);
}
var importer = existing[0];
var existingDepot = db.Depots.Where(i => i.ImporterId == importer.Id).ToList();
if (!existingDepot.Any())
{
return(-2);
}
var existingp = db.People.Where(i => i.Id == person.PersonId).ToList();
if (!existingp.Any())
{
return(-2);
}
importer.Name = person.CompanyName;
importer.IsActive = person.IsActive;
var prs = existingp[0];
prs.FirstName = person.FirstName;
prs.LastName = person.LastName;
var depotEntity = existingDepot[0];
depotEntity.Name = person.CompanyName;
db.Entry(importer).State = EntityState.Modified;
db.SaveChanges();
db.Entry(prs).State = EntityState.Modified;
db.SaveChanges();
db.Entry(depotEntity).State = EntityState.Modified;
db.SaveChanges();
return(importer.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long AddUserAndPersonInfo(UserProfileObject user)
{
try
{
if (user == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var banks = db.Banks.Where(v => v.ImporterId == user.CompanyId).ToList();
if (!banks.Any())
{
return(-2);
}
var bank = banks[0];
long personId = 0;
if (db.People.Any())
{
var existingp = db.People.OrderByDescending(i => i.Id).Take(1).ToList();
if (!existingp.Any())
{
personId = 1;
}
else
{
personId = existingp[0].Id + 1;
}
}
else
{
personId = 1;
}
var person = new Person
{
Id = personId,
FirstName = user.FirstName,
LastName = user.LastName,
ImporterId = bank.ImporterId,
IsAdmin = user.IsAdmin
};
var res = db.People.Add(person);
db.SaveChanges();
return(res.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long UpdateImporterDepotAndPerson(UserProfileObject person)
{
try
{
return(_importerManager.UpdateImporterDepotAndPerson(person));
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int UpdateUserProfile(UserProfileObject person)
{
try
{
return(_personRepository.UpdateUserProfile(person));
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public long AddImporterDepotAndPerson(UserProfileObject person)
{
try
{
if (person == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var importer = new Importer
{
Name = person.CompanyName,
IsActive = true,
DateAdded = DateTime.Now.ToString("yyyy/MM/dd")
};
var returnStatus = db.Importers.Add(importer);
db.SaveChanges();
var prs = new Person
{
FirstName = person.FirstName,
LastName = person.LastName,
ImporterId = returnStatus.Id,
IsAdmin = true,
IsImporter = false,
};
var depotEntity = new Depot
{
Name = importer.Name,
ImporterId = returnStatus.Id,
JettyId = person.JettyId
};
db.Depots.Add(depotEntity);
db.SaveChanges();
var prsId = db.People.Add(prs);
db.SaveChanges();
return(prsId.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public static UserProfileObject GetUserProfile(Guid user_id)
{
UserProfileObject user = new UserProfileObject();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_CST465"].ConnectionString))
{
SqlCommand command = new SqlCommand("UserProfile_Get", connection);
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserId", user_id));
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.Read()) // retrive the first row from the command
{
user.UserID = (Guid)reader[0];
user.FirstName = (String)reader[1];
user.LastName = (String)reader[2];
user.Age = (int)reader[3];
user.PhoneNumber = (String)reader[4];
user.Email = (String)reader[5];
user.Address = (String)reader[6];
user.City = (String)reader[7];
user.State = (String)reader[8];
user.ZipCode = (String)reader[9];
user.Image = (reader[10] == System.DBNull.Value) ? null : (byte[])reader[10];
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
}
}
return(user);
}
public static UserProfileObject GetUserProfile(Guid user_id)
{
UserProfileObject user = new UserProfileObject();
using (SqlConnection connection = new SqlConnection(ConfigurationManager.ConnectionStrings["DB_CST465"].ConnectionString))
{
SqlCommand command = new SqlCommand("UserProfile_Get", connection);
command.Connection.Open();
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add(new SqlParameter("@UserId", user_id));
try
{
SqlDataReader reader = command.ExecuteReader();
if (reader.Read()) // retrive the first row from the command
{
user.UserID = (Guid)reader[0];
user.FirstName = (String)reader[1];
user.LastName = (String)reader[2];
user.Age = (int)reader[3];
user.PhoneNumber = (String)reader[4];
user.Email = (String)reader[5];
user.Address = (String)reader[6];
user.City = (String)reader[7];
user.State = (String)reader[8];
user.ZipCode = (String)reader[9];
user.Image = (reader[10] == System.DBNull.Value) ? null : (byte[])reader[10];
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
command.Connection.Close();
}
}
return user;
}
public long UpdateUserAndPersonInfo(UserProfileObject user)
{
try
{
if (user == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var persons = db.People.Where(v => v.Id == user.PersonId).ToList();
if (!persons.Any())
{
return(-2);
}
var person = persons[0];
var usps = db.UserProfiles.Where(o => o.PersonId == person.Id).ToList();
if (!usps.Any())
{
return(-2);
}
var usp = usps[0];
person.FirstName = user.FirstName;
person.LastName = user.LastName;
usp.IsActive = user.IsActive;
db.Entry(person).State = EntityState.Modified;
db.SaveChanges();
db.Entry(usp).State = EntityState.Modified;
db.SaveChanges();
return(person.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public long UpdateUser(UserProfileObject person)
{
try
{
if (person == null)
{
return(-2);
}
using (var db = new ImportPermitEntities())
{
var existingp = db.UserProfiles.Where(i => i.PersonId == person.PersonId).Include("Person").ToList();
if (!existingp.Any())
{
return(-2);
}
var prs = existingp[0];
prs.IsActive = person.IsActive;
prs.Person.FirstName = person.FirstName;
prs.Person.LastName = person.LastName;
db.Entry(prs).State = EntityState.Modified;
db.SaveChanges();
db.Entry(prs.Person).State = EntityState.Modified;
db.SaveChanges();
return(prs.Id);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(0);
}
}
public int UpdateCustomer(UserProfileObject customer)
{
return(_customerRepository.UpdateCustomer(customer));
}
public long UpdateSalePayment(SaleObject sale, UserProfileObject userProfile)
{
return(_saleRepository.UpdateSalePayment(sale, userProfile));
}
public long AddCustomer(UserProfileObject user)
{
try
{
if (user == null || user.CustomerObjects == null || !user.CustomerObjects.Any() || user.DeliveryAddressObject == null || user.DeliveryAddressObject.CityId < 1)
{
return(-2);
}
using (var db = _dbStoreEntities)
{
var duplicateMobiles = db.UserProfiles.Count(m => m.MobileNumber == user.MobileNumber);
if (duplicateMobiles > 0)
{
return(-3);
}
if (!string.IsNullOrEmpty(user.ContactEmail))
{
var duplicateMails = db.UserProfiles.Count(m => m.ContactEmail == user.ContactEmail);
if (duplicateMails > 0)
{
return(-4);
}
}
var userEntity = ModelCrossMapper.Map <UserProfileObject, UserProfile>(user);
if (userEntity == null || string.IsNullOrEmpty(userEntity.LastName) || string.IsNullOrEmpty(userEntity.OtherNames))
{
return(-2);
}
userEntity.IsActive = true;
var processedUser = db.UserProfiles.Add(userEntity);
db.SaveChanges();
var customerInfo = user.CustomerObjects.ToList()[0];
var customer = new Customer
{
DateProfiled = DateTime.Now,
StoreCustomerTypeId = customerInfo.StoreCustomerTypeId,
StoreOutletId = customerInfo.StoreOutletId,
ContactPersonId = user.ContactPersonId,
UserId = processedUser.Id
};
var processedCustomer = db.Customers.Add(customer);
db.SaveChanges();
var deliveryAddress = new DeliveryAddress
{
CustomerId = processedCustomer.CustomerId,
AddressLine1 = user.DeliveryAddressObject.AddressLine1,
AddressLine2 = user.DeliveryAddressObject.AddressLine2,
CityId = user.DeliveryAddressObject.CityId,
MobileNumber = user.MobileNumber,
TelephoneNumber = user.OfficeLine,
ContactEmail = user.ContactEmail
};
db.DeliveryAddresses.Add(deliveryAddress);
db.SaveChanges();
return(processedUser.Id);
}
}
catch (DbEntityValidationException e)
{
var str = "";
foreach (var eve in e.EntityValidationErrors)
{
str += string.Format("Entity of type \"{0}\" in state \"{1}\" has the following validation errors:",
eve.Entry.Entity.GetType().Name, eve.Entry.State) + "\n";
foreach (var ve in eve.ValidationErrors)
{
str += string.Format("- Property: \"{0}\", Error: \"{1}\"",
ve.PropertyName, ve.ErrorMessage) + " \n";
}
}
ErrorLogger.LogError(e.StackTrace, e.Source, str);
return(0);
}
}
public int UpdateCustomer(UserProfileObject user)
{
try
{
if (user == null || user.CustomerObjects == null || user.DeliveryAddressObject == null || user.DeliveryAddressObject.CityId < 1)
{
return(-2);
}
using (var db = _dbStoreEntities)
{
var duplicateMobiles = db.UserProfiles.Count(m => m.MobileNumber == user.MobileNumber && m.Id != user.Id);
if (duplicateMobiles > 0)
{
return(-3);
}
if (!string.IsNullOrEmpty(user.ContactEmail))
{
var duplicateMails = db.UserProfiles.Count(m => m.ContactEmail == user.ContactEmail && m.Id != user.Id);
if (duplicateMails > 0)
{
return(-4);
}
}
var userEntities = db.UserProfiles.Where(p => p.Id == user.Id).ToList();
if (!userEntities.Any())
{
return(0);
}
var userEntity = userEntities[0];
var customerInfo = user.CustomerObjects.ToList()[0];
var customers = db.Customers.Where(p => p.CustomerId == customerInfo.CustomerId).ToList();
if (!customers.Any())
{
return(0);
}
var deliveryAddresses = db.DeliveryAddresses.Where(d => d.Id == user.DeliveryAddressObject.Id).ToList();
if (!deliveryAddresses.Any())
{
return(0);
}
var customerEntity = customers[0];
userEntity.LastName = user.LastName;
userEntity.OtherNames = user.OtherNames;
userEntity.Gender = user.Gender;
userEntity.Birthday = user.Birthday;
userEntity.ContactEmail = user.ContactEmail;
userEntity.MobileNumber = user.MobileNumber;
userEntity.OfficeLine = user.OfficeLine;
db.Entry(userEntity).State = EntityState.Modified;
db.SaveChanges();
customerEntity.StoreCustomerTypeId = customerInfo.StoreCustomerTypeId;
customerEntity.ContactPersonId = user.ContactPersonId;
if (customerInfo.StoreOutletId > 0)
{
customerEntity.StoreOutletId = customerInfo.StoreOutletId;
}
db.Entry(customerEntity).State = EntityState.Modified;
db.SaveChanges();
var deliveryAddress = deliveryAddresses[0];
deliveryAddress.MobileNumber = user.MobileNumber;
deliveryAddress.TelephoneNumber = user.OfficeLine;
deliveryAddress.ContactEmail = user.ContactEmail;
deliveryAddress.AddressLine1 = user.DeliveryAddressObject.AddressLine1;
deliveryAddress.AddressLine2 = user.DeliveryAddressObject.AddressLine2;
deliveryAddress.CityId = user.DeliveryAddressObject.CityId;
db.Entry(deliveryAddress).State = EntityState.Modified;
db.SaveChanges();
return(5);
}
}
catch (Exception ex)
{
ErrorLogger.LogError(ex.StackTrace, ex.Source, ex.Message);
return(-2);
}
}
public UserProfileObject GetBankAdmin(int bankId)
{
try
{
using (var db = new ImportPermitEntities())
{
var bankUser = new UserProfileObject();
var bankAdmins = (from bk in
db.Banks.Where(m => m.BankId == bankId)
join cm in db.Importers on bk.ImporterId equals cm.Id
join cp in db.People on cm.Id equals cp.ImporterId
join us in db.UserProfiles.Where(n => n.IsAdmin) on cp.Id equals us.PersonId
join id in db.AspNetUsers on us.Id equals id.UserInfo_Id
select new UserProfileObject
{
Id = us.Id,
BankId = bk.BankId,
UserId = id.Id,
PhoneNumber = id.PhoneNumber,
CompanyId = cm.Id,
PersonId = cp.Id,
FirstName = cp.FirstName,
LastName = cp.LastName,
Email = id.Email,
IsActive = us.IsActive
}).ToList();
if (!bankAdmins.Any())
{
var banks = (from bk in db.Banks.Where(m => m.BankId == bankId)
join cm in db.Importers on bk.ImporterId equals cm.Id
select bk).ToList();
if (!banks.Any())
{
return(new UserProfileObject());
}
bankUser.BankId = banks[0].BankId;
bankUser.CompanyId = banks[0].ImporterId;
}
else
{
bankUser = bankAdmins[0];
var branchUsers = db.BankUsers.Where(b => b.UserId == bankUser.Id).Include("BankBranch").ToList();
if (branchUsers.Any())
{
var branch = branchUsers[0];
bankUser.BranchCode = branch.BankBranch.BranchCode;
bankUser.BankBranchName = branch.BankBranch.Name;
bankUser.BranchId = branch.BranchId;
}
}
if (bankUser.BankId < 1)
{
return(new UserProfileObject());
}
return(bankUser);
}
}
catch (Exception ex)
{
ErrorLogger.LoggError(ex.StackTrace, ex.Source, ex.Message);
return(new UserProfileObject());
}
}
public long AddCustomer(UserProfileObject customer)
{
return(_customerRepository.AddCustomer(customer));
}
