public IActionResult Put([FromBody] SubSupplier model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
if (!validateEntity(model))
{
return(InvalidModelStateResult());
}
if (repository.Get().Count(a => a.SubSupplierId.Equals(model.SubSupplierId)) == 0)
{
return(NotFound(Constants.ErrorMessages.NotFoundEntity));
}
return(Accepted(repository.Update(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.UpdateError));
}
}
private void Loadsubsupplier(Model.Supplier supplier, IList <SubSupplier> lstDeputy = null)
{
if (m_Suplier == null)
{
return;
}
if (lstDeputy == null)
{
using (IUnitOfWork uow = new UnitOfWork())
{
lstDeputy = uow.SubSupplierRepository.GetbySupplier(supplier);
uow.Commit();
}
}
gridUtility1.BindingData <SubSupplier>(lstDeputy);
if (lstDeputy != null)
{
m_Subsupplier = lstDeputy.Where(p => p.IsMain == true).FirstOrDefault();
if (m_Subsupplier == null)
{
m_Subsupplier = new SubSupplier();
}
InitializeForm(m_Subsupplier);
}
//cbbIsMainDeputy.Checked = deputy.IsMain;
}
public SqlRawParameter GetSqlRawParameter(SubSupplier parameters)
{
if (parameters == null)
{
return(new SqlRawParameter());
}
var sqlQry = new StringBuilder();
sqlQry.AppendLine("SELECT * FROM SubSuppliers");
var whereClauses = new List <string>();
var sqlParams = new List <SqlParameter>();
if (!parameters.SubSupplierName.IsNull())
{
sqlParams.Add(new SqlParameter(nameof(parameters.SubSupplierName).Parametarize(), parameters.SubSupplierName));
whereClauses.Add($"{nameof(parameters.SubSupplierName)} = {nameof(parameters.SubSupplierName).Parametarize()}");
}
if (whereClauses.Count > 0)
{
sqlQry.AppendLine(" WHERE ");
sqlQry.AppendLine(String.Join(" AND ", whereClauses.ToArray()));
}
return(new SqlRawParameter()
{
SqlParameters = sqlParams, SqlQuery = sqlQry.ToString()
});
}
private void InitializeForm(SubSupplier subsupplier)
{
m_User = subsupplier.User;
if (subsupplier.User == null)
{
m_User = new Users();
}
CoverObjectUtility.SetAutoBindingData(this, m_User);
CoverObjectUtility.SetAutoBindingData(this, subsupplier);
cbbIsMainDeputy.Checked = subsupplier.IsMain;
cbActive.Checked = subsupplier.IsActive;
if (subsupplier.User.Sex == true)
{
rdNam.Checked = true;
}
else
{
rdNu.Checked = true;
}
if (subsupplier.SubSupplierId <= 0)
{
btnSaveDeputy.Visible = false;
}
else
{
btnSaveDeputy.Visible = true;
}
}
private void btnDeleteAccount_Click(object sender, EventArgs e)
{
int i = gridView1.GetSelectedRows().FirstOrDefault();
if (m_User == null || m_Subsupplier == null)
{
return;
}
try
{
using (IUnitOfWork uow = new UnitOfWork())
{
uow.DeputyRepository.Remove(m_Subsupplier.SubSupplierId);
uow.UsersRepository.Remove(m_User.UserId);
uow.Commit();
}
m_Subsupplier = new SubSupplier();
m_User = new Users();
InitializeForm(m_Subsupplier);
gridView1.DeleteRow(i);
lblNotify1.SetText(UI.removesuccess, LabelNotify.EnumStatus.Success);
}
catch
{
lblNotify1.SetText(UI.removefailed, LabelNotify.EnumStatus.Failed);
}
}
public int Update(Supplier entry)
{
Users user = entry.User;
SubSupplier subSupplier = entry.SubSupplier;
if (user == null || subSupplier == null)
{
return(-1);
}
user.SetModify();
using (IUnitOfWork uow = new UnitOfWork())
{
var userUpdate = uow.UsersRepository.Find(user.UserId);
var supplierUpdate = uow.SupplierRepository.Find(entry.SupplierId);
if (userUpdate == null || supplierUpdate == null)
{
return(-1);
}
userUpdate.Email = user.Email;
userUpdate.FullName = user.FullName;
userUpdate.SetModify();
userUpdate.Sex = user.Sex;
supplierUpdate.SupplierName = entry.SupplierName;
supplierUpdate.Taxcode = entry.Taxcode;
supplierUpdate.TypeId = entry.TypeId;
supplierUpdate.Website = entry.Website;
supplierUpdate.TagetValue = entry.TagetValue;
supplierUpdate.SetModify();
uow.UsersRepository.Update(userUpdate);
uow.SupplierRepository.Update(supplierUpdate);
uow.SubSupplierRepository.Update(subSupplier);
uow.Commit();
}
return(entry.SupplierId);
}
public SubSupplier Create(SubSupplier model)
{
var exist = dbContext.SubSuppliers.FirstOrDefault(a => a.SubSupplierName == model.SubSupplierName);
dbContext.SubSuppliers.Add(model);
dbContext.SaveChanges();
return(model);
}
public GroupSupplier AddandGetSupplierID(Supplier entry, string parrentgroup)
{
GroupSupplier groupSuppler = new GroupSupplier();
Users user = entry.User;
SubSupplier subSupplier = entry.SubSupplier;
if (user == null || subSupplier == null)
{
groupSuppler = null;
}
int idUser = -1;
user.SetCreate();
groupSuppler = new GroupSupplier
{
GroupName = entry.SupplierName,
ParentGroup = int.Parse(parrentgroup)
};
try
{
using (IUnitOfWork uow = new UnitOfWork())
{
idUser = uow.UsersRepository.AddAndGetID(user);
if (idUser < 0)
{
return(null);
}
entry.SetCreate();
entry.GroupId = uow.SupplierRepository.AddGroup(groupSuppler);
if (entry.GroupId < 0)
{
return(null);
}
groupSuppler.GroupId = entry.GroupId;
entry.SupplierId = uow.SupplierRepository.AddandGetSupplierID(entry);
if (entry.SupplierId < 0)
{
return(null);
}
subSupplier.UserId = idUser;
subSupplier.SetCreate();
subSupplier.SupplierId = entry.SupplierId;
subSupplier.IsMain = true;
subSupplier.IsActive = true;
uow.SubSupplierRepository.Add(subSupplier);
uow.Commit();
}
}
catch (Exception)
{
return(null);
}
return(groupSuppler);
}
private bool validateEntity(SubSupplier model)
{
var validName = repository.ValidateName(model);
if (!validName)
{
ModelState.AddModelError(nameof(SubSupplier.SubSupplierName), Constants.ErrorMessages.EntityExists("Name"));
}
return(ModelState.ErrorCount == 0);
}
public bool ValidateName(SubSupplier model)
{
var existing = Get().FirstOrDefault(a => a.SubSupplierName == model.SubSupplierName.Trim());
if (existing == null)
{
return(true);
}
return(existing.SubSupplierId == model.SubSupplierId);
}
public IQueryable <SubSupplier> Get(SubSupplier parameters = null)
{
var sqlRawParams = GetSqlRawParameter(parameters);
if (sqlRawParams.SqlParameters.Count == 0)
{
return(dbContext.SubSuppliers.AsNoTracking());
}
return(dbContext.SubSuppliers.FromSqlRaw(sqlRawParams.SqlQuery, sqlRawParams.SqlParameters.ToArray()).AsNoTracking());
}
public static Users GetUser(SubSupplier subsupplier)
{
Users user;
using (IUnitOfWork uow = new UnitOfWork())
{
user = uow.UsersRepository.Find(subsupplier.UserId);
uow.Commit();
}
return(user);
}
public IActionResult Get([FromQuery] SubSupplier parameters = null)
{
try
{
var model = repository.Get(parameters);
return(Ok(model));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.FetchError));
}
}
public SubSupplier Update(SubSupplier model)
{
var entity = dbContext.SubSuppliers.AsNoTracking().FirstOrDefault(a => a.SubSupplierId == model.SubSupplierId);
if (entity == null)
{
throw new Exception("Selected Record does not exists.");
}
entity.SubSupplierName = model.SubSupplierName;
entity.IsActive = model.IsActive;
dbContext.SubSuppliers.Update(entity);
dbContext.SaveChanges();
return(entity);
}
private void gridView1_RowClick_1(object sender, DevExpress.XtraGrid.Views.Grid.RowClickEventArgs e)
{
gridUtility1.SetRowColor();
m_Subsupplier = gridUtility1.GetSelectedItem <SubSupplier>();
if (m_Subsupplier == null)
{
return;
}
m_User = UtilityFunction.GetUser(m_Subsupplier);
if (m_User == null)
{
m_User = new Users();
}
m_Subsupplier.User = m_User;
InitializeForm(m_Subsupplier);
}
private void CreateNewSupplierMenu(object sender, EventArgs e)
{
currentNode = nodeRight;
m_Suplier = new Model.Supplier();
m_Suplier = null;
m_Subsupplier = null;
//FormUtility.ResetForm(this);
while (gridView1.RowCount != 0)
{
gridView1.SelectAll();
gridView1.DeleteSelectedRows();
}
if (m_Suplier == null)
{
m_Suplier = new Model.Supplier();
InitializeForm(m_Suplier);
}
txtsupplierName.Focus();
}
public int AddandGetSupplierID(Supplier entry)
{
Users user = entry.User;
SubSupplier subSupplier = entry.SubSupplier;
if (user == null || subSupplier == null)
{
return(-1);
}
int idUser = -1;
user.SetCreate();
try
{
using (IUnitOfWork uow = new UnitOfWork())
{
idUser = uow.UsersRepository.AddAndGetID(user);
if (idUser < 0)
{
return(-1);
}
entry.SetCreate();
entry.SupplierId = uow.SupplierRepository.AddandGetSupplierID(entry);
if (entry.SupplierId < 0)
{
return(-1);
}
subSupplier.UserId = idUser;
subSupplier.SetCreate();
subSupplier.SupplierId = entry.SupplierId;
subSupplier.IsMain = true;
subSupplier.IsActive = true;
uow.SubSupplierRepository.Add(subSupplier);
uow.Commit();
}
}
catch (Exception)
{
return(-2);
}
return(entry.SupplierId);
}
public SubSupplier CheckAndAdd(string name)
{
if (String.IsNullOrEmpty(name))
{
return(null);
}
if (Get().Count(a => a.SubSupplierName == name.Trim()) == 0)
{
var newModel = new SubSupplier()
{
SubSupplierName = name, IsActive = true
};
dbContext.SubSuppliers.Add(newModel);
dbContext.SaveChanges();
return(newModel);
}
return(null);
}
public IActionResult ValidateName([FromBody] SubSupplier model)
{
if (model == null)
{
return(NotFound());
}
if (General.IsDevelopment)
{
logger.LogDebug(ModelState.ToJson());
}
var result = repository.ValidateName(model);
if (result)
{
return(Accepted(true));
}
else
{
return(UnprocessableEntity(Constants.ErrorMessages.EntityExists("Name")));
}
}
public IActionResult Post([FromBody] SubSupplier model)
{
try
{
if (!ModelState.IsValid)
{
return(InvalidModelStateResult());
}
if (!validateEntity(model))
{
return(InvalidModelStateResult());
}
return(Accepted(repository.Create(model)));
}
catch (Exception ex)
{
logger.LogError(ex.GetExceptionMessages());
return(StatusCode(StatusCodes.Status500InternalServerError, Constants.ErrorMessages.CreateError));
}
}
public FrmSupplier()
{
InitializeComponent();
FormUtility.FormatForm(this);
lblNotify1.Text = "";
m_Suplier = null;
m_Subsupplier = null;
m_User = null;
IGridviewContextMenu ctx = new CompanyContextMenu();
IGridviewContextMenu ctxDeputy = new DeputyContextMenu();
gridUtility1 = new GridUtility(gridControl1, ctxDeputy);
ImageList myImageList = new ImageList();
myImageList = new ImageList();
myImageList.Images.Add(TmTech_v1.Properties.Resources.iconSelect);
myImageList.Images.Add(TmTech_v1.Properties.Resources.folder);
myImageList.Images.Add(TmTech_v1.Properties.Resources.warming);
treeviewsupplier.ImageList = myImageList;
treeviewsupplier.SelectedImageIndex = 0;
treeviewsupplier.DrawNode += Treeviewsupplier_DrawNode;
}
public bool Delete(SubSupplier model)
{
dbContext.SubSuppliers.Remove(model);
dbContext.SaveChanges();
return(true);
}
public bool ValidateCode(SubSupplier model)
{
throw new NotImplementedException();
}
private SubSupplier SaveAccount(Users user)
{
int supplierId = string.IsNullOrWhiteSpace(txtsupplierId.Text) == false?Convert.ToInt32(txtsupplierId.Text) : 0;
if (supplierId <= 0)
{
lblNotify1.SetText(UI.deputyhasnocompany, LabelNotify.EnumStatus.Failed);
return(null);
}
if (ValidationUtility.IsTextAllowed(user.UserName) == false)
{
lblNotify1.SetText(UI.usernotallowspace, LabelNotify.EnumStatus.Failed);
return(null);
}
user.Sex = rdNam.Checked == true ? true : false;
user.SetCreate();
user.UserGroupId = (int)UserTypeFlag.Customer;
m_Subsupplier = new SubSupplier();
CoverObjectUtility.GetAutoBindingData(groupSubsupplier, m_Subsupplier);
if (user.UserId <= 0)
{
m_Subsupplier.SubSupplierId = 0;
}
m_Subsupplier.SubSupplierName = user.FullName;
m_Subsupplier.IsActive = cbActive.Checked;
m_Subsupplier.Email = user.Email;
m_Subsupplier.Phone = user.Phone;
m_Subsupplier.Address = user.Address;
m_Subsupplier.Sex = user.Sex;
m_Subsupplier.UserId = user.UserId;
m_Subsupplier.SupplierId = supplierId;
IList <SubSupplier> lstExistsDeputy = gridControl1.DataSource as IList <SubSupplier>;
SubSupplier main = lstExistsDeputy != null?lstExistsDeputy.Where(p => p.IsMain == true && p.SubSupplierId != m_Subsupplier.SubSupplierId).FirstOrDefault() : null;
if (main == null)
{
m_Subsupplier.IsMain = true;
}
else
{
m_Subsupplier.IsMain = false;
}
using (IUnitOfWork uow = new UnitOfWork())
{
if (user.UserId <= 0)
{
uow.UsersRepository.Add(user);
m_Subsupplier.SetCreate();
m_Subsupplier.UserId = user.UserId;
m_Subsupplier.SubSupplierId = 0;
uow.SubSupplierRepository.Add(m_Subsupplier);
}
else
{
uow.UsersRepository.Update(user);
m_Subsupplier.SetModify();
uow.SubSupplierRepository.Update(m_Subsupplier);
}
uow.Commit();
}
return(m_Subsupplier);
}
