public bool InsertOrUpdate(MiniUnit MURecord)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
if (MURecord.MiniUnitId == 0)
{
db.MiniUnit.Add(MURecord);
}
else
{
db.MiniUnit.AddOrUpdate(MURecord);
}
db.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
isSaved = false;
}
}
return(isSaved);
}
public bool Delete(int MiniUnitId)
{
bool isDeleted = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
mu = db.MiniUnit.Find(MiniUnitId);
db.MiniUnit.Remove(mu);
db.SaveChanges();
}
catch (Exception e)
{
string message = e.Message;
isDeleted = false;
}
}
return(isDeleted);
}
public bool UpdateBalanceAllowedStorage(int MiniUnitId, bool BalanceToStorageAllowed)
{
bool isSaved = true;
using (WTCCeresEntities db = new WTCCeresEntities())
{
try
{
mu = db.MiniUnit.Find(MiniUnitId);
mu.BalanceToStorageAllowed = BalanceToStorageAllowed;
db.MiniUnit.AddOrUpdate(mu);
db.SaveChanges();
}
catch (Exception ex)
{
string message = ex.Message;
isSaved = false;
}
}
return(isSaved);
}
private void tbCreateUnits_Click(object sender, EventArgs e)
{
if (MandatoryFieldsOk())
{
var unitService = new UnitSourceService();
int insertedUSId;
var muService = new MiniUnitService();
string unitBilled;
if (cboCargoType.Text.Equals("BULK"))
{
unitBilled = Conversions.ToString(cboWeightUnit.SelectedItem);
}
else
{
unitBilled = "PC";
}
// My.MyProject.Forms.FrmParentScreen.showLOadForm();
foreach (var unit in UnitList)
{
UnitSource ExistingUnit;
MiniUnit mu;
if (unit.UnitId != 0)
{
ExistingUnit = AllUnits.Where(u => u.UnitSourceId == unit.UnitId).ToList()[0];
// ExistingUnit.UnitStatusId = cboStatus.SelectedValue
ExistingUnit.UnitType = Conversions.ToString(cboType.SelectedItem);
ExistingUnit.CargoTypeId = Conversions.ToInteger(cboCargoType.SelectedValue);
ExistingUnit.LastUpdate = DateAndTime.Now;
ExistingUnit.TotalBilled = (double?)unit.TotalBilled;
ExistingUnit.OriginalUnitNumber = unit.OriginalUnitNumber;
bool isSaved = unitService.AddOrUpdate(ExistingUnit);
insertedUSId = unit.UnitId;
var muList = new List <MiniUnit>();
muList = MiniUnitService.GetAllByUSId(unit.UnitId);
foreach (var currentMu in muList)
{
mu = currentMu;
if (muList.Count == 1)
{
mu.TotalBilled = unit.TotalBilled;
}
mu.BilledByUnitUnitType = unitBilled;
mu.UnBilledByUnitUnitType = unitBilled;
mu.CustomerId = Conversions.ToInteger(cboCustomer.SelectedValue);
mu.GradeId = Conversions.ToInteger(cboGrade.SelectedValue);
mu.CommodityId = Conversions.ToInteger(cboCommodity.SelectedValue);
muService.InsertOrUpdate(mu);
}
}
else
{
var us = new UnitSource();
us.UnitNumber = unit.UnitNumber;
us.OriginalUnitNumber = unit.OriginalUnitNumber;
us.UnitStatusId = unit.UnitStatusId;
us.UnitType = Conversions.ToString(cboType.SelectedItem);
us.CargoTypeId = Conversions.ToInteger(cboCargoType.SelectedValue);
us.OriginLocation = "";
us.UnitLine = "";
us.ETALocation = "";
us.Sequence = "";
us.Track = "";
us.LastLocation = "";
us.DemurageDays = 0;
us.InTransitDays = 0;
us.TotalBilled = (double?)unit.TotalBilled;
us.LastUpdate = DateAndTime.Now;
us.ActiveUpdates = true;
us.Active = true;
us.RecordKey = 0;
us.CargoDescription = "";
us.ShipperId = 0;
us.ETADate = default;
us.BillDate = default;
us.CallDate = default;
us.AvailableDate = default;
us.ArrivalDate = default;
us.ReleaseDate = default;
unitService.AddOrUpdate(us);
insertedUSId = unitService.GetLastUnitSourceId();
mu = new MiniUnit();
mu.MiniUnitOrder = 1;
mu.UnitSourceId = insertedUSId;
mu.TotalBilled = unit.TotalBilled;
mu.UnBilled = 0;
mu.BilledByUnit = 0;
mu.BilledByUnitUnitType = unitBilled;
mu.UnBilledByUnit = 0;
mu.UnBilledByUnitUnitType = unitBilled;
mu.MULocation = "";
mu.Comments = "";
mu.CustomerId = Conversions.ToInteger(cboCustomer.SelectedValue);
mu.GradeId = Conversions.ToInteger(cboGrade.SelectedValue);
mu.CommodityId = Conversions.ToInteger(cboCommodity.SelectedValue);
mu.BalanceToStorageAllowed = true;
mu.isMultiMU = false;
muService.InsertOrUpdate(mu);
}
}
// My.MyProject.Forms.FrmParentScreen.HideLoadForm();
var result = My.MyProject.Forms.MessageBoxCeresYesNo.ShowDialog("Success!", "Units added with success. Do you want continue creating/updating units?", My.Resources.Resources.icon_available, this);
if (!(result == DialogResult.Yes))
{
Close();
}
else
{
UnitList.Clear();
AllUnits = UnitSourceService.GetByActiveStatus(Conversions.ToBoolean(1));
tbUnits.Text = "";
}
}
}
public bool InsertOrUpdate(MiniUnit MURecord)
{
return(repository.InsertOrUpdate(MURecord));
}
