public async Task <VmGenericServiceResult> Update(VmDocumentItem vmItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.Document entity = await documentRepo.Get(vmItem.Id);
Copy <VmDocumentItem, Com.BudgetMetal.DBEntities.Document>(vmItem, entity);
if (entity.UpdatedBy.IsNullOrEmpty())
{
entity.UpdatedBy = "System";
}
documentRepo.Update(entity);
documentRepo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public VmGenericServiceResult Insert(VmDocumentItem vmItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.Document entity = new Com.BudgetMetal.DBEntities.Document();
Copy <VmDocumentItem, Com.BudgetMetal.DBEntities.Document>(vmItem, entity);
entity.Company_Id = (int)vmItem.Company_Id;
entity.DocumentStatus_Id = (int)vmItem.DocumentStatus_Id;
entity.DocumentType_Id = (int)vmItem.DocumentType_Id;
if (entity.CreatedBy.IsNullOrEmpty())
{
entity.CreatedBy = entity.UpdatedBy = "System";
}
documentRepo.Add(entity);
documentRepo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public VmGenericServiceResult Insert(VmEmailLogItem vmtem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.EmailLog r = new Com.BudgetMetal.DBEntities.EmailLog();
Copy <VmEmailLogItem, Com.BudgetMetal.DBEntities.EmailLog>(vmtem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> Update(VmCodeTableItem vmCodeTableItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeTable r = await repo.Get(vmCodeTableItem.Id);
Copy <VmCodeTableItem, CodeTable>(vmCodeTableItem, r);
if (r.UpdatedBy.IsNullOrEmpty())
{
r.UpdatedBy = "System";
}
repo.Update(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> Update(VmCompanyItem vmCompanyItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.Company r = await repo.Get(vmCompanyItem.Id);
Copy <VmCompanyItem, Com.BudgetMetal.DBEntities.Company>(vmCompanyItem, r);
if (r.UpdatedBy.IsNullOrEmpty())
{
r.UpdatedBy = "System";
}
r.IsVerified = vmCompanyItem.IsVerified;
repo.Update(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public VmGenericServiceResult Insert(VmServiceTagsItem vmtem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.ServiceTags r = new Com.BudgetMetal.DBEntities.ServiceTags();
Copy <VmServiceTagsItem, Com.BudgetMetal.DBEntities.ServiceTags>(vmtem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
// r.Industry_Id = 1;//hard code
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> Insert(VmRatingItem vmRatingItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
BudgetMetal.DBEntities.Rating r = new BudgetMetal.DBEntities.Rating();
Copy <VmRatingItem, BudgetMetal.DBEntities.Rating>(vmRatingItem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public VmGenericServiceResult Insert(VmCodeTableItem vmCodeTableItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeTable r = new CodeTable();
Copy <VmCodeTableItem, CodeTable>(vmCodeTableItem, r);
r.CodeCategory_Id = (int)vmCodeTableItem.CodeCategory_Id;
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public VmGenericServiceResult Insert(VmIndustryItem vmtem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Industry r = new Industry();
Copy <VmIndustryItem, Industry>(vmtem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> ResetPassword(string username)
{
var result = new VmGenericServiceResult();
var dbresult = await repo.GetUserByUserNameOrEmail(username);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
//dbresult.Password = Md5.Encrypt(newPassword);
//repo.Update(dbresult);
//repo.Commit();
result.IsSuccess = true;
//generate reset password link
string link = "";
string encryptedUserName = System.Net.WebUtility.UrlEncode(Md5.Encrypt(dbresult.UserName));
string encryptedValidDate = System.Net.WebUtility.UrlEncode(Md5.Encrypt(DateTime.Now.ToString("yyyy-mm-dd")));
link = "u=" + encryptedUserName + "&d=" + encryptedValidDate;
result.MessageToUser = dbresult.EmailAddress + ",#," + link;
//result.MessageToUser = "******" + dbresult.EmailAddress+").";
}
return(result);
}
public async Task <VmGenericServiceResult> ConfirmUserName(string Username)
{
var result = new VmGenericServiceResult();
var dbresult = await repo.GetUserByUserName(Username);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
if (dbresult.IsConfirmed)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
dbresult.IsConfirmed = true;
repo.Update(dbresult);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
}
return(result);
}
public async Task <VmGenericServiceResult> EditCompanyUserRole(int companyId, int userId, string[] userRole, string updatedBy)
{
var result = new VmGenericServiceResult();
string roleName = "";
var dbRoleUser = userRoleRepository.GetUserRolesByUserId(userId);
if (dbRoleUser != null)
{
foreach (var item in dbRoleUser.Result)
{
DBEntities.UserRoles userRoles = await userRoleRepository.Get(item.Id);
userRoleRepository.Delete(userRoles);
}
userRoleRepository.Commit();
}
foreach (var role in userRole)
{
if (role != null)
{
int roleId = int.Parse(role);
var dbRoleUserResult = await userRoleRepository.GetUserRolesByUserIdRoleId(userId, roleId);
if (dbRoleUserResult == null)
{
DBEntities.UserRoles userRoles = new DBEntities.UserRoles();
userRoles.User_Id = userId;
userRoles.IsActive = true;
userRoles.UpdatedBy = updatedBy;
userRoles.Role_Id = roleId;
userRoleRepository.Add(userRoles);
}
else
{
dbRoleUserResult.IsActive = true;
dbRoleUserResult.UpdatedBy = updatedBy;
dbRoleUserResult.Role_Id = roleId;
userRoleRepository.Update(dbRoleUserResult);
}
var roleEntity = roleRepository.Get(roleId);
if (roleEntity != null)
{
roleName += roleEntity.Result.Name + "|";
}
result.IsSuccess = true;
}
else
{
result.IsSuccess = true;
}
}
result.MessageToUser = roleName.TrimEnd('|');
userRoleRepository.Commit();
return(result);
}
public VmGenericServiceResult Insert(VmCompanyItem vmItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.Company r = new Com.BudgetMetal.DBEntities.Company();
Copy <VmCompanyItem, Com.BudgetMetal.DBEntities.Company>(vmItem, r);
r.IsVerified = false;
r.AwardedQuotation = 0;
r.SubmittedQuotation = 0;
r.BuyerAvgRating = 0;
r.SupplierAvgRating = 0;
//Max Default RFQ Per Week
var codeTableRepo = this.codeTableRepo.Get(10100001);
int maxQuotationPerWeek = Convert.ToInt32(codeTableRepo.Result.Value);
//Max Default Quote Per Week
codeTableRepo = this.codeTableRepo.Get(10100002);
int maxRFQPerWeek = Convert.ToInt32(codeTableRepo.Result.Value);
r.MaxQuotationPerWeek = maxQuotationPerWeek;
r.MaxRFQPerWeek = maxRFQPerWeek;
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> PostMessage(string message)
{
var result = new VmGenericServiceResult();
try
{
//var appIdTask = repoCodeTable.Get(Constants_CodeTable.Code_SiteOption_Fb_App_Id);
//var secretTask = repoCodeTable.Get(Constants_CodeTable.Code_SiteOption_Fb_App_Secret);
var PageIdTask = repoCodeTable.Get(Constants_CodeTable.Code_SiteOption_Fb_PageId);
//Task.WaitAll(new[] { appIdTask, secretTask, PageIdTask });
Task.WaitAll(new[] { PageIdTask });
//string app_id = appIdTask.Result.Value;
//string app_secret = secretTask.Result.Value;
string accessToken = await GetAccessTokenAsync();
string page_id = PageIdTask.Result.Value;
string app_id = _appId;
string app_secret = _secret;
var client = new FacebookClient(accessToken);
client.AppId = app_id;
client.AppSecret = app_secret;
dynamic parameters = new ExpandoObject();
parameters.message = message;
client.Post("/" + page_id + "/feed", parameters);
result.IsSuccess = true;
result.MessageToUser = "******";
}
catch (Exception ex)
{
result.IsSuccess = false;
result.MessageToUser = "******" + ex.Message;
result.Error = ex;
}
return(result);
}
public async Task <VmGenericServiceResult> Update(VmUserItem vObj)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.User dbObj = await repo.Get(vObj.Id);
Copy <VmUserItem, Com.BudgetMetal.DBEntities.User>(vObj, dbObj);
if (vObj.RoleList != null && vObj.RoleList.Count > 0)
{
foreach (var vUsrRole in vObj.RoleList)
{
var dbRoleObj = await roleRepo.Get(vUsrRole.Id);
if (dbRoleObj != null)
{
UserRoles ur = new UserRoles();
ur.Role = dbRoleObj;
ur.PrepareNewRecord("System");
dbObj.UserRoles.Add(ur);
}
}
}
dbObj.PrepareNewRecord("System");
repo.Update(dbObj);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> EditCompanyUser(int companyId, int userId, bool isActiveStatus, string updatedBy)
{
var result = new VmGenericServiceResult();
var dbresult = await repoUser.GetUserCompanyIdandUserId(companyId, userId);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
dbresult.IsConfirmed = isActiveStatus;
dbresult.UpdatedBy = updatedBy;
repoUser.Update(dbresult);
repoUser.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
return(result);
}
public async Task <VmGenericServiceResult> EditCompanyAddress(int companyId, string address, string updatedBy)
{
var result = new VmGenericServiceResult();
var dbresult = await repo.Get(companyId);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
dbresult.Address = address;
dbresult.UpdatedBy = updatedBy;
repo.Update(dbresult);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
return(result);
}
public async Task <VmGenericServiceResult> ChangePassword(int id, string password)
{
var result = new VmGenericServiceResult();
var dbresult = await repo.GetUserById(id);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
dbresult.Password = Md5.Encrypt(password);
repo.Update(dbresult);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
return(result);
}
public VmGenericServiceResult Insert(VmCodeCategoryItem vmCodeCategoryItem)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
CodeCategory r = new CodeCategory();
Copy <VmCodeCategoryItem, CodeCategory>(vmCodeCategoryItem, r);
if (r.CreatedBy.IsNullOrEmpty())
{
r.CreatedBy = r.UpdatedBy = "System";
}
repo.Add(r);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
var repoEntity = repo.Get(vmCodeCategoryItem.Id);
if (repoEntity != null)
{
Exception ee = new Exception("Id is already existed!");
result.Error = ee;
}
else
{
result.Error = e;
}
}
return(result);
}
public async Task <VmGenericServiceResult> ResetPass(string username, string password)
{
var result = new VmGenericServiceResult();
string newPassword = Md5.Encrypt(password);
username = Md5.Decrypt(username);
var dbresult = await repo.GetUserByUserName(username);
if (dbresult == null)
{
result.IsSuccess = false;
result.MessageToUser = "******";
}
else
{
dbresult.Password = newPassword;
repo.Update(dbresult);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = "******";
}
return(result);
}
public async Task <VmGenericServiceResult> Insert(VmUserItem vObj)
{
VmGenericServiceResult result = new VmGenericServiceResult();
try
{
Com.BudgetMetal.DBEntities.User dbObj = new Com.BudgetMetal.DBEntities.User();
Copy <VmUserItem, Com.BudgetMetal.DBEntities.User>(vObj, dbObj);
#region comments
// r.Industry_Id = 1;//hard code
//var user = new[]
//{
// new User { Id = r.Id },
// //new User {Id = 2}
//};
////var role = new Role { Id = 1 };
////var role1 = new Role { Id = 2 };
//var role = new[]
//{
// new Role {Id=1},
// new Role {Id=2}
//};
//r.UserRoles.Add(new UserRoles { User = user[0], Role = role[0] });
//r.UserRoles.Add(new UserRoles { User = user, Role = role1 });
//foreach (var post in UserRoles)
//{
// var oldPostTag = post.PostTags.FirstOrDefault(e => e.Tag.Text == "Pineapple");
// if (oldPostTag != null)
// {
// post.PostTags.Remove(oldPostTag);
// post.PostTags.Add(new PostTag { Post = post, Tag = newTag1 });
// }
// post.PostTags.Add(new PostTag { Post = post, Tag = newTag2 });
//}
//UserRoles _userRole = new UserRoles();
////_userRole.User = user[0];
//_userRole.User_Id = r.Id;
//_userRole.Role_Id = 1;
////_userRole.Role = role[0];
//userRolesRepo.Add(_userRole);
//userRolesRepo.Commit();
#endregion
if (vObj.RoleList != null && vObj.RoleList.Count > 0)
{
foreach (var vUsrRole in vObj.RoleList)
{
var dbRoleObj = await roleRepo.Get(vUsrRole.Id);
if (dbRoleObj != null)
{
UserRoles ur = new UserRoles();
ur.Role = dbRoleObj;
ur.PrepareNewRecord("System");
dbObj.UserRoles.Add(ur);
}
}
}
dbObj.PrepareNewRecord("System");
repo.Add(dbObj);
repo.Commit();
result.IsSuccess = true;
}
catch (Exception e)
{
result.IsSuccess = false;
result.Error = e;
}
return(result);
}
public async Task <VmGenericServiceResult> Register(VmUserItem user, string[] serviceTags)
{
var result = new VmGenericServiceResult();
try
{
int companyId = 0;
if (user.Company.Id > 0)
{
companyId = user.Company.Id;
}
else
{
var dbCompany = new Com.BudgetMetal.DBEntities.Company();
Copy <VmCompanyItem, Com.BudgetMetal.DBEntities.Company>(user.Company, dbCompany);
var dbMaxDefaultRFQ = await CTrepo.Get(Constants_CodeTable.Code_MaxDefaultRFQPerWeek);
dbCompany.MaxRFQPerWeek = Convert.ToInt32(dbMaxDefaultRFQ.Value);
var dbMaxDefaultQuote = await CTrepo.Get(Constants_CodeTable.Code_MaxDefaultQuotePerWeek);
dbCompany.MaxQuotationPerWeek = Convert.ToInt32(dbMaxDefaultQuote.Value);
dbCompany.IsVerified = false;
dbCompany.SupplierAvgRating = dbCompany.BuyerAvgRating = dbCompany.AwardedQuotation = dbCompany.SubmittedQuotation = 0;
dbCompany.C_BusinessType = Constants_CodeTable.Code_C_Supplier;
dbCompany.CreatedBy = dbCompany.UpdatedBy = user.UserName;
var dbResultCompany = cRepo.Add(dbCompany);
cRepo.Commit();
companyId = dbResultCompany.Id;
if (serviceTags != null)
{
foreach (var item in serviceTags)
{
var dbSupplierServicTags = new SupplierServiceTags();
dbSupplierServicTags.Company_Id = companyId;
dbSupplierServicTags.ServiceTags_Id = Convert.ToInt32(item);
dbSupplierServicTags.CreatedBy = dbSupplierServicTags.UpdatedBy = user.UserName;
supplierServiceTagsRepo.Add(dbSupplierServicTags);
}
supplierServiceTagsRepo.Commit();
}
}
var dbUser = new User();
Copy <VmUserItem, Com.BudgetMetal.DBEntities.User>(user, dbUser, new string[] { "Company" });
dbUser.Company_Id = companyId;
dbUser.Password = Common.Md5.Encrypt(dbUser.Password);
dbUser.CreatedBy = dbUser.UpdatedBy = user.UserName;
dbUser.IsConfirmed = false;
dbUser.UserType = Constants_CodeTable.Code_Supplier;
var dbResultUser = repo.Add(dbUser);
repo.Commit();
result.IsSuccess = true;
result.MessageToUser = user.EmailAddress;
}
catch (Exception ex)
{
result.IsSuccess = false;
result.MessageToUser = ex.Message;
result.Error = ex;
}
return(result);
}