protected void btn_sure_Click(object sender, EventArgs e)
{
Company company = this.AddCompany();
CompanyProvider provider = new CompanyProvider();
switch (this.OperationFlag)
{
case Operation.Add:
if (this.IsSame() == 1)
{
break;
}
if (provider.Insert(company))
{
this.Alert("添加成功!!!");
this.TextCancel();
}
break;
case Operation.Update:
if (provider.Update(company))
{
this.Alert("修改成功!!!");
this.BindText();
}
break;
}
}
/// <summary>
/// 编辑公司信息
/// </summary>
/// <returns></returns>
public ActionResult Edit()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
string CompanyName = WebUtil.GetFormValue <string>("CompanyName");
CompanyProvider provider = new CompanyProvider();
CompanyEntity entity = new CompanyEntity();
entity.CompanyID = CompanyID;
entity.CompanyName = CompanyName;
int line = provider.Update(entity);
DataResult dataResult = new DataResult();
if (line > 0)
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "编辑成功";
}
else
{
dataResult.Code = (int)EResponseCode.Exception;
dataResult.Message = "编辑失败";
}
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public async Task <IHttpActionResult> RegisterCompany(RegisterCompanyBindingModel model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
using (LoanAndRepayEntities entities = new LoanAndRepayEntities())
{
var companyName = entities.CompanyInfoes.FirstOrDefault(x => x.CompanyName == model.CompanyName);
if (companyName == null)
{
var user = new ApplicationUser()
{
UserName = model.Email, Email = model.Email
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
var UserId = UserManager.FindByEmail(model.Email);
//Calling provider to save data
CompanyProvider.SaveCompanyInfo(model, UserId.Id);
UserManager.AddToRole(UserId.Id, "Company");
}
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
return(Ok());
}
}
return(BadRequest("Company name is already taken"));
}
/// <summary>
/// Конвертация в компанию поставщика
/// </summary>
/// <param name="client">Компания поставщик БД</param>
/// <returns>Компания поставщик </returns>
public static CompanyProvider Convert(CompanyProviderEnt companyProvider, bool logic = true)
{
if (companyProvider != null)
{
List <ContactInformation> list = null;
List <InvoiceForPurchase> invoiceForPurchaseEnts = null;
if (logic == true)
{
list = new List <ContactInformation>();
foreach (var item in companyProvider.ContactInformation)
{
list.Add(Convert(item));
}
invoiceForPurchaseEnts = new List <InvoiceForPurchase>();
foreach (var item in companyProvider.InvoiceForPurchases)
{
invoiceForPurchaseEnts.Add(Convert(item, false));
}
}
CompanyProvider companyProviderEnt = new CompanyProvider
{
InvoiceForPurchases = invoiceForPurchaseEnts,
Description = companyProvider.Description,
Id = companyProvider.Id,
Name = companyProvider.Name,
ContactInformation = list
};
return(companyProviderEnt);
}
else
{
return(null);
}
}
public async Task <IHttpActionResult> Register_Company(RegisterCompany model)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
var user = new ApplicationUser()
{
UserName = model.Email, Email = model.Email
};
IdentityResult result = await UserManager.CreateAsync(user, model.Password);
if (result.Succeeded)
{
var UserId = UserManager.FindByEmail(model.Email);
CompanyProvider.SaveCompanyInfo(model, UserId.Id);
CompanyProvider.SaveCategory(model, UserId.Id);
UserManager.AddToRole(UserId.Id, "Company");
}
if (!result.Succeeded)
{
return(GetErrorResult(result));
}
return(Ok());
}
protected void GridView_InitNewRow(object sender, DevExpress.Web.Data.ASPxDataInitNewRowEventArgs e)
{
CompanyVM CloneItem = new CompanyVM();
if (bool.Parse(HttpContext.Current.Session["isCloneRow_Com"].ToString()) == true && GridView.FocusedRowIndex >= 0)
{
//List<int> selectedIds = GridView.GetSelectedFieldValues("Id").ConvertAll(id => (int)id);
//CloneItem = CompanyProvider.GetSingleById(selectedIds.Last());
CloneItem = Mapper.Map <CompanyVM>(CompanyProvider.GetSingleById(GridView.GetRowValues(GridView.FocusedRowIndex, "Id").ToString()));
HttpContext.Current.Session["isCloneRow_Com"] = false;
PropertyInfo myFieldInfo;
foreach (var myProperty in typeof(CompanyVM).GetProperties())
{
myFieldInfo = typeof(CompanyVM).GetProperty(myProperty.Name);
if (myFieldInfo == null)
{
continue;
}
var ttt = myFieldInfo.GetValue(CloneItem);
e.NewValues[myProperty.Name] = myFieldInfo.GetValue(CloneItem);
}
}
}
public async Task <HttpResponseMessage> Conversation(ConversationViewModel conversation)
{
MitBudDBEntities mitBudDB = new MitBudDBEntities();
var userId = RequestContext.Principal.Identity.GetUserId();
var CompanyEmail = mitBudDB.Companies.Where(x => x.UserId == userId).SingleOrDefault();
//var clientEmail = mitBudDB.Clients.Where(x => x.Client_Id == conversation.Client_id).SingleOrDefault();
var clientId = mitBudDB.Tasks.Where(x => x.TaskId == conversation.TaskID).SingleOrDefault();
//var companyName = CompanyEmail.CompanyName;
CompanyProvider.SaveConversation(conversation, userId, clientId.Client_id);
var statusCode = HttpStatusCode.Accepted;
var responseMsg = new HttpResponseMessage(statusCode)
{
Content = new StringContent("", Encoding.UTF8, "application/json")
};
Email.sendNotificationEmail(clientId.ClientName, clientId.ClientEmail, CompanyEmail.CompanyName);
return(responseMsg);
}
private void BindSource()
{
CompanyProvider provider = new CompanyProvider();
this.ddl_company.DataSource = provider.GetAll();
this.ddl_company.DataBind();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
int rowIndex = e.RowIndex;
Company company = new Company();
company.Company_id = Convert.ToInt32(this.GridView1.DataKeys[rowIndex].Value);
CompanyProvider provider = new CompanyProvider();
if (provider.Delete(company))
{
this.Alert("删除成功!!!");
if (this.txt_Name.Text == "")
{
this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1;
this.BindSource(null);
}
else
{
this.ListPager1.RecordCount = this.ListPager1.RecordCount - 1;
this.BindSource("%" + this.txt_Name.Text + "%");
}
}
}
/// <summary>
/// 新增公司信息
/// </summary>
/// <returns></returns>
public ActionResult Add()
{
string CompanyNum = WebUtil.GetFormValue <string>("CompanyNum");
string CompanyName = WebUtil.GetFormValue <string>("CopanyName");
string CreateUser = WebUtil.GetFormValue <string>("CreateUser");
CompanyEntity entity = new CompanyEntity();
entity.CompanyNum = CompanyNum;
entity.CompanyName = CompanyName;
entity.CreateUser = CreateUser;
CompanyProvider provider = new CompanyProvider();
int line = provider.Add(entity);
DataResult dataResult = new DataResult();
if (line > 0)
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "新增成功";
}
else
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "新增失败";
}
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public void ConvertToViewTest()
{
CompanyProvider target = new CompanyProvider(); // TODO: Initialize to an appropriate value
Company item = _Company;
baseCompanyView expected = _baseCompanyView;
baseCompanyView actual;
actual = target.ConvertToView(item);
CompareViewObject(expected, actual);
}
public void ConvertToModelTest()
{
CompanyProvider target = new CompanyProvider(); // TODO: Initialize to an appropriate value
baseCompanyView item = _baseCompanyView;
Company expected = _Company;
Company actual;
actual = target.ConvertToModel(item);
CompareModelObject(expected, actual);
}
// GET: CompanyProviders/Edit/5
public ActionResult Edit(int id)
{
CompanyProvider item = CompanyProviderMethods.GetItem(id);
if (item == null)
{
return(HttpNotFound());
}
return(View(item));
}
protected void btn_Result_Click(object sender, EventArgs e)
{
Company company = new Company();
company.Company_name = "%" + this.txt_Name.Text + "%";
CompanyProvider provider = new CompanyProvider();
this.ListPager1.RecordCount = provider.GetSize(company);
this.BindSource(0, "%" + this.txt_Name.Text + "%");
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
IEnumerable <CompanyVM> GetData(string ID)
{
CompanyVM item = Mapper.Map <CompanyVM>(CompanyProvider.GetSingleById(ID));
List <CompanyVM> ItemList = new List <CompanyVM>();
if (item != null)
{
ItemList.Add(item);
}
return(ItemList);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
CompanyProvider provider = new CompanyProvider();
this.ListPager1.RecordCount = provider.GetSize();
this.BindSource(0, null);
}
this.account.Text = Session["LOGINED"].ToString();
this.datetime.Text = this.BindDayWeek();
this.ListPager1.PageChange += new PagerEventHandler(ListPager1_PageChange);
}
public async Task <HttpResponseMessage> Conversation(ConversationViewModel conversation)
{
var userId = RequestContext.Principal.Identity.GetUserId();
CompanyProvider.SaveConversation(conversation, userId);
var statusCode = HttpStatusCode.Accepted;
var responseMsg = new HttpResponseMessage(statusCode)
{
Content = new StringContent("", Encoding.UTF8, "application/json")
};
return(responseMsg);
}
public ActionResult Create(Provider provider)
{
if (ModelState.IsValid)
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
db.Providers.Add(provider);
var responseSave = DBHelper.SaveChanges(db);
if (!responseSave.Succeeded)
{
ModelState.AddModelError(string.Empty, responseSave.Message);
transaction.Rollback();
ViewBag.CityId = new SelectList(CombosHelper.GetCities(provider.DepartamentsId), "CityId", "Name");
ViewBag.DepartamentsId = new SelectList(CombosHelper.GetDepartments(), "DepartamentsId", "Name");
return(View(provider));
}
UsersHelper.CreateUserASP(provider.UserName, "Provider");
//SALVAR OS DADOS NA TABELA COMPANY PROVIDER
var user = db.Users.Where(u => u.UserName == User.Identity.Name).FirstOrDefault();
var companyProvider = new CompanyProvider()
{
CompanyId = user.CompanyId,
ProviderId = provider.ProviderId
};
db.CompanyProviders.Add(companyProvider);
db.SaveChanges();
transaction.Commit();
return(RedirectToAction("Index"));
}
catch (Exception ex)
{
transaction.Rollback();
ModelState.AddModelError(string.Empty, ex.Message);
}
}
}
ViewBag.CityId = new SelectList(CombosHelper.GetCities(provider.DepartamentsId), "CityId", "Name");
ViewBag.DepartamentsId = new SelectList(CombosHelper.GetDepartments(), "DepartamentsId", "Name");
return(View(provider));
}
public ActionResult Edit(CompanyProvider item)
{
try
{
if (ModelState.IsValid)
{
CompanyProviderMethods.ChangeItem(item);
return(RedirectToAction("Index"));
}
}
catch (DataException)
{
//Log the error (add a variable name after DataException)
ModelState.AddModelError("", "Unable to save changes. Try again, and if the problem persists see your system administrator.");
}
return(View(item));
}
public void ConvertToViewListTest()
{
CompanyProvider target = new CompanyProvider(); // TODO: Initialize to an appropriate value
List <Company> itemlist = new List <Company>();
itemlist.Add(_Company);
itemlist.Add(_Company);
List <baseCompanyView> expected = new List <baseCompanyView>();
expected.Add(_baseCompanyView);
expected.Add(_baseCompanyView);
List <baseCompanyView> actual;
actual = target.ConvertToViewList(itemlist);
Assert.AreEqual(expected.Count, actual.Count);
CompareViewObject(expected[0], actual[0]);
CompareViewObject(expected[1], actual[1]);
}
private int IsSame()
{
Company company = new Company();
CompanyProvider provider = new CompanyProvider();
company.Company_num = Convert.ToInt32(this.txt_company_num.Text);
DataTable table = new DataTable();
table = provider.Select(company);
if (table.Rows.Count != 0)
{
this.Alert("该编号已经存在，请重新输入！！！");
return(1);
}
else
{
return(0);
}
}
/// <summary>
/// 绑定Company信息的数据源
/// </summary>
private void BindSource(int start, string name)
{
if (name != null)
{
Company company = new Company();
company.Company_name = name;
CompanyProvider provider = new CompanyProvider();
DataTable table = provider.Select(company, start, this.ListPager1.PageSize);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
else
{
CompanyProvider provider = new CompanyProvider();
DataTable table = provider.GetAll(start, this.ListPager1.PageSize);
this.GridView1.DataSource = table.DefaultView;
this.GridView1.DataBind();
}
}
/// <summary>
/// 删除公司信息
/// </summary>
/// <returns></returns>
public ActionResult Delete()
{
string CompanyID = WebUtil.GetFormValue <string>("CompanyID");
CompanyProvider provider = new CompanyProvider();
int line = provider.Delete(CompanyID);
DataResult dataResult = new DataResult();
if (line > 0)
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "删除成功";
}
else
{
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "删除失败";
}
return(Content(JsonHelper.SerializeObject(dataResult)));
}
/// <summary>
/// 查询公司分页列表
/// </summary>
/// <returns></returns>
public ActionResult GetList()
{
int PageIndex = WebUtil.GetFormValue <int>("PageIndex");
int PageSize = WebUtil.GetFormValue <int>("PageSize");
CompanyProvider provider = new CompanyProvider();
PageInfo pageInfo = new PageInfo()
{
PageIndex = PageIndex, PageSize = PageSize
};
CompanyEntity entity = new CompanyEntity();
List <CompanyEntity> listResult = provider.GetList(entity, ref pageInfo);
DataListResult <CompanyEntity> dataResult = new DataListResult <CompanyEntity>();
dataResult.Code = (int)EResponseCode.Success;
dataResult.Message = "响应成功";
dataResult.Result = listResult;
dataResult.PageInfo = pageInfo;
return(Content(JsonHelper.SerializeObject(dataResult)));
}
public IHttpActionResult CompanyCredit()
{
MitBudDBEntities mitBud = new MitBudDBEntities();
var userId = RequestContext.Principal.Identity.GetUserId();
var findCompanyCredit = mitBud.Companies.Where(x => x.UserId == userId).SingleOrDefault();
if (findCompanyCredit != null)
{
var substractCompanyCredit = findCompanyCredit.CompanyCredit = findCompanyCredit.CompanyCredit - 1;
if (substractCompanyCredit > -1)
{
CompanyProvider.updateCredit(substractCompanyCredit, userId);
}
else
{
return(Content(HttpStatusCode.BadRequest, "You have no credit left"));
}
}
else
{
return(NotFound());
}
return(Ok());
// var dd = HttpStatusCode.Accepted;
// var responseMsg = new HttpResponseMessage(dd)
// {
// Content = new StringContent("", Encoding.UTF8, "application/json")
// };
//}
}
private void BindText()
{
Company company = new Company();
company.Company_id = Convert.ToInt32(id);
CompanyProvider provider = new CompanyProvider();
DataTable table = new DataTable();
table = provider.Select(company);
this.txt_company_address.Text = table.Rows[0]["company_address"].ToString();
this.txt_company_cell.Text = table.Rows[0]["company_cell"].ToString();
this.txt_company_city.Text = table.Rows[0]["company_city"].ToString();
this.txt_company_email.Text = table.Rows[0]["company_email"].ToString();
this.txt_company_fax.Text = table.Rows[0]["company_fax"].ToString();
this.txt_company_manager.Text = table.Rows[0]["company_manager"].ToString();
this.txt_company_name.Text = table.Rows[0]["company_name"].ToString();
this.txt_company_nation.Text = table.Rows[0]["company_nation"].ToString();
this.txt_company_num.Text = table.Rows[0]["company_num"].ToString();
this.txt_company_phone.Text = table.Rows[0]["company_phone"].ToString();
this.txt_company_postcode.Text = table.Rows[0]["company_postcode"].ToString();
this.txt_company_pro.Text = table.Rows[0]["company_pro"].ToString();
}
/// <summary>
/// 查询公司信息
/// </summary>
/// <returns></returns>
public ActionResult GetSingle()
{
DataResult <CompanyEntity> result = null;
string CompanyNum = WebUtil.GetFormValue <string>("CompanyNum", string.Empty);
if (CompanyNum.IsEmpty())
{
result = new DataResult <CompanyEntity>()
{
Code = (int)EResponseCode.Exception, Message = "公司编号为空"
};
return(Content(JsonHelper.SerializeObject(result)));
}
CompanyProvider provider = new CompanyProvider();
CompanyEntity entity = provider.GetSingle(CompanyNum);
result = new DataResult <CompanyEntity>()
{
Code = (int)EResponseCode.Success, Message = "响应成功", Result = entity
};
return(Content(JsonHelper.SerializeObject(result)));
}
/// <summary>
/// Конвертация в компанию поставщика БД
/// </summary>
/// <param name="client">Компания поставщик </param>
/// <returns>Компания поставщик БД </returns>
public static CompanyProviderEnt Convert(CompanyProvider companyProvider)
{
if (companyProvider != null)
{
var x = Unit.CompanyProviderRepository.GetItem(companyProvider.Id);
if (x != null)
{
return(x);
}
else
{
List <ContactInformationEnt> list = new List <ContactInformationEnt>();
foreach (var item in companyProvider.ContactInformation)
{
list.Add(Convert(item));
}
List <InvoiceForPurchaseEnt> invoiceForPurchaseEnts = new List <InvoiceForPurchaseEnt>();
foreach (var item in companyProvider.InvoiceForPurchases)
{
invoiceForPurchaseEnts.Add(Convert(item));
}
CompanyProviderEnt companyProviderEnt = new CompanyProviderEnt
{
InvoiceForPurchases = invoiceForPurchaseEnts,
Description = companyProvider.Description,
Id = companyProvider.Id,
Name = companyProvider.Name,
ContactInformation = list
};
return(companyProviderEnt);
}
}
else
{
return(null);
}
}
private ResponseModel <Company> Save(int id, Company model)
{
//check duplicate for subdomain
if (model.ScriptFieldCollection?.Count > 0)
{
bool hasDuplicate = _context.Companies.Any(t => t.DeletedOn == null && t.SubDomain == model.SubDomain && t.CompanyId != model.CompanyId);
if (!hasDuplicate)
{
CompanyProvider companyProvider = new CompanyProvider(_context);
companyProvider.Save(model);
return(new ResponseModel <Company>
{
Message = id > 0 ? "Successfully updated Company" : "Successfully added Company",
StatusCode = 1,
ResponseObject = model
});
}
else
{
return(new ResponseModel <Company>
{
Message = "Subdomain already exists",
StatusCode = 2
});
}
}
else
{
return(new ResponseModel <Company>
{
Message = "Minimum 1 script field is required",
StatusCode = 2
});
}
}
private void UpdateNavBarName()
{
List <bool> ActivedList = new List <bool>();
List <bool> BlockedList = new List <bool>();
for (int i = 0; i < GridView.VisibleRowCount; i++)
{
ActivedList.Add((bool)GridView.GetRowValues(i, "Actived"));
BlockedList.Add((bool)GridView.GetRowValues(i, "Blocked"));
}
GridView.JSProperties["cpActived"] = ActivedList;
GridView.JSProperties["cpBlocked"] = BlockedList;
HttpContext.Current.Session["isActBloChanged_Com"] = false;
GridView.JSProperties["cpAllCount"] = CompanyProvider.Count(x => true);
GridView.JSProperties["cpInActivedUnBlockedCount"] = CompanyProvider.Count(x => x.Actived == false && x.Blocked == false);
GridView.JSProperties["cpActivedBlockedCount"] = CompanyProvider.Count(x => x.Actived == true && x.Blocked == true);
GridView.JSProperties["cpInactivedBlockedCount"] = CompanyProvider.Count(x => x.Actived == false && x.Blocked == true);
GridView.JSProperties["cpActivedUnBlockedCount"] = CompanyProvider.Count(x => x.Actived == true && x.Blocked == false);
GridView.JSProperties["cpUpdatedByCount"] = CompanyProvider.Count(x => x.CreatedBy == User.Identity.Name || x.UpdatedBy == User.Identity.Name);
GridView.JSProperties["cpOwnerCount"] = CompanyProvider.Count(x => x.UserName == User.Identity.Name);
}
