public void Insert(RepackModel model)
{
var sSql = @"
INSERT INTO
Repack (
RepackID, Tgl, Jam, BPStokID,
BrgIDMaterial, QtyMaterial, HppMaterial,
BrgIDHasil, SlotControl, QtyHasil, HppHasil)
VALUES (
@RepackID, @Tgl, @Jam, @BPStokID,
@BrgIDMaterial, @QtyMaterial, @HppMaterial,
@BrgIDHasil, @SlotControl, @QtyHasil, @HppHasil) ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@RepackID", model.RepackID);
cmd.AddParam("@Tgl", model.Tgl.ToTglYMD());
cmd.AddParam("@Jam", model.Jam);
cmd.AddParam("@BPStokID", model.BPStokID);
cmd.AddParam("BrgIDMaterial", model.BrgIDMaterial);
cmd.AddParam("@QtyMaterial", model.QtyMaterial);
cmd.AddParam("@HppMaterial", model.HppMaterial);
cmd.AddParam("BrgIDHasil", model.BrgIDHasil);
cmd.AddParam("@QtyHasil", model.QtyHasil);
cmd.AddParam("@HppHasil", model.HppHasil);
cmd.AddParam("@SlotControl", model.SlotControl);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public void Save()
{
var repack = new RepackModel
{
RepackID = _view.RepackID,
Tgl = _view.Tgl,
Jam = _view.Jam,
BPStokID = _view.BPStokID,
BrgIDMaterial = _view.BrgIDMaterial,
BrgNameMaterial = _view.BrgNameMaterial,
QtyMaterial = _view.QtyMaterial,
HppMaterial = _view.HppMaterial,
BrgIDHasil = _view.BrgIDHasil,
BrgNameHasil = _view.BrgIDHasil,
QtyHasil = _view.QtyHasil,
HppHasil = _view.HppHasil,
SlotControl = _view.SlotControl
};
using (var trans = TransHelper.NewScope())
{
var result = _repackBL.Save(repack);
var result2 = _bpStokBL.Generate(result);
trans.Complete();
}
}
public IEnumerable <RepackModel> ListData(string tgl1, string tgl2)
{
List <RepackModel> result = null;
var sSql = @"
SELECT
aa.RepackID, aa.Tgl, aa.Jam, aa.BPStokID,
aa.BrgIDMaterial, aa.QtyMaterial, aa.HppMaterial,
aa.BrgIDHasil, aa.SlotControl, aa.QtyHasil, aa.HppHasil,
ISNULL(bb.BrgName, '') BrgNameMaterial,
ISNULL(cc.BrgName, '') BrgNameHasil
FROM
Repack aa
LEFT JOIN Brg bb ON aa.BrgIDMaterial = bb.BrgID
LEFT JOIN Brg cc ON aa.BrgIDHasil = cc.BrgID
WHERE
Tgl BETWEEN @Tgl1 AND @Tgl2 ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@Tgl1", tgl1.ToTglYMD());
cmd.AddParam("@Tgl2", tgl2.ToTglYMD());
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
result = new List <RepackModel>();
while (dr.Read())
{
var item = new RepackModel
{
RepackID = dr["RepackID"].ToString(),
Tgl = dr["Tgl"].ToString().ToTglDMY(),
Jam = dr["Jam"].ToString(),
BPStokID = dr["BPStokID"].ToString(),
BrgIDMaterial = dr["BrgIDMaterial"].ToString(),
BrgNameMaterial = dr["BrgNameMaterial"].ToString(),
QtyMaterial = Convert.ToInt64(dr["QtyMaterial"]),
HppMaterial = Convert.ToDecimal(dr["HppMaterial"]),
BrgIDHasil = dr["BrgIDHasil"].ToString(),
BrgNameHasil = dr["BrgNameHasil"].ToString(),
SlotControl = dr["SlotControl"].ToString(),
QtyHasil = Convert.ToInt64(dr["QtyHasil"]),
HppHasil = Convert.ToDecimal(dr["HppHasil"])
};
result.Add(item);
}
}
}
return(result);
}
private async Task OnSubmit()
{
try
{
IsBusy = true;
RepackRequestModel context = new RepackRequestModel
{
Account = _packingSlip.Account.Key,
Note = _note,
PackingSlip = _packingSlip.Key,
RecId = _packingSlip.RecId.ToLong(),
SalesOrder = _packingSlip.Order.Key,
};
var modelList = new List <RepackModel>();
foreach (var packingSlipWithRePacking in _packingSlip.Lines.Where(p => p.PackingReasonList?.Any() ?? false))
{
var rpackModel = new RepackModel
{
LineItem = packingSlipWithRePacking.Key,
Reasons = packingSlipWithRePacking.PackingReasonList.Select(p => new PackReason
{
Action = p.Action.Key,
InventTransId = (int)packingSlipWithRePacking.InventTransId.ToLong(),
Quantity = p.Quantity,
Reason = p.Reason.Key
}).ToList()
};
modelList.Add(rpackModel);
}
context.Data = modelList;
var submitResponse = await Api.RepackPackingSlip(context);
if (!submitResponse.Successful.GetValueOrDefault())
{
await Alert.DisplayApiCallError(submitResponse.ExceptionMessage, submitResponse.ValidationErrors,
Translate.Get(nameof(AppResources.CouldNotSubmitRepacking)));
return;
}
await Nav.Nav.PopAsync();
}
catch (Exception e)
{
await AlertService.Instance.DisplayError(e);
}
finally
{
IsBusy = false;
}
}
public RepackModel GetData(string id)
{
RepackModel result = null;
var sSql = @"
SELECT
aa.RepackID, aa.Tgl, aa.Jam, aa.BPStokID,
aa.BrgIDMaterial, aa.QtyMaterial, aa.HppMaterial,
aa.BrgIDHasil, aa.SlotControl, aa.QtyHasil, aa.HppHasil,
ISNULL(bb.BrgName, '') BrgNameMaterial,
ISNULL(cc.BrgName, '') BrgNameHasil
FROM
Repack aa
LEFT JOIN Brg bb ON aa.BrgIDMaterial = bb.BrgID
LEFT JOIN Brg cc ON aa.BrgIDHasil = cc.BrgID
WHERE
RepackID = @RepackID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@RepackID", id);
conn.Open();
using (var dr = cmd.ExecuteReader())
{
if (!dr.HasRows)
{
return(null);
}
dr.Read();
result = new RepackModel
{
RepackID = dr["RepackID"].ToString(),
Tgl = dr["Tgl"].ToString().ToTglDMY(),
Jam = dr["Jam"].ToString(),
BPStokID = dr["BPStokID"].ToString(),
BrgIDMaterial = dr["BrgIDMaterial"].ToString(),
BrgNameMaterial = dr["BrgNameMaterial"].ToString(),
QtyMaterial = Convert.ToInt64(dr["QtyMaterial"]),
HppMaterial = Convert.ToDecimal(dr["HppMaterial"]),
BrgIDHasil = dr["BrgIDHasil"].ToString(),
BrgNameHasil = dr["BrgNameHasil"].ToString(),
SlotControl = dr["SlotCOntrol"].ToString(),
QtyHasil = Convert.ToInt64(dr["QtyHasil"]),
HppHasil = Convert.ToDecimal(dr["HppHasil"])
};
}
cmd.ExecuteNonQuery();
}
return(result);
}
public IEnumerable <BPStokModel> Generate(RepackModel repack)
{
List <BPStokModel> result = null;
if (repack == null)
{
throw new ArgumentNullException(nameof(repack));
}
// ambil data data material untuk dikurangi stok-nya
var stokMaterial = new StokItem
{
ReffID = repack.RepackID,
Tgl = repack.Tgl,
Jam = repack.Jam,
BrgID = repack.BrgIDMaterial,
BrgName = repack.BrgNameMaterial,
QtyIn = 0,
NilaiHpp = 0,
QtyOut = repack.QtyMaterial,
HargaJual = 0,
BPStokID = repack.BPStokID,
};
var bpStokMaterial = RemoveStok(stokMaterial);
// insert data hasil untuk ditambahkan stoknya
var stokHasil = new StokItem
{
ReffID = repack.RepackID,
Tgl = repack.Tgl,
Jam = repack.Jam,
BrgID = repack.BrgIDHasil,
BrgName = repack.BrgNameHasil,
QtyIn = repack.QtyHasil,
NilaiHpp = repack.HppHasil,
QtyOut = 0,
HargaJual = 0,
BPStokID = repack.SlotControl,
};
var bpStokHasil = AddStok(stokHasil);
// update stok info
_brgStokHargaBL.UpdateStok(repack.BrgIDMaterial);
_brgStokHargaBL.UpdateStok(repack.BrgIDHasil);
return(result);
}
public void Update(RepackModel model)
{
var sSql = @"
UPDATE
Repack
SET
Tgl = @Tgl,
Jam = @Jam,
BPStokID = @BPStokID,
BrgIDMaterial = @BrgIDMaterial,
QtyMaterial = @QtyMaterial,
HppMaterial = @HppMaterial,
BrgIDHasil = @BrgIDHasil,
SlotControl = @SlotControl,
QtyHasil = @QtyHasil,
HppHasil = @HppHasil,
WHERE
RepackID = @RepackID ";
using (var conn = new SqlConnection(_connString))
using (var cmd = new SqlCommand(sSql, conn))
{
cmd.AddParam("@RepackID", model.RepackID);
cmd.AddParam("@Tgl", model.Tgl.ToTglYMD());
cmd.AddParam("@Jam", model.Jam);
cmd.AddParam("@BPStokID", model.BPStokID);
cmd.AddParam("BrgIDMaterial", model.BrgIDMaterial);
cmd.AddParam("@QtyMaterial", model.QtyMaterial);
cmd.AddParam("@HppMaterial", model.HppMaterial);
cmd.AddParam("BrgIDHasil", model.BrgIDHasil);
cmd.AddParam("SlotControl", model.SlotControl);
cmd.AddParam("@QtyHasil", model.QtyHasil);
cmd.AddParam("@HppHasil", model.HppHasil);
conn.Open();
cmd.ExecuteNonQuery();
}
}
public RepackModel Save(RepackModel model)
{
if (model == null)
{
throw new ArgumentNullException(nameof(model));
}
// validasi tgl
if (!model.Tgl.IsValidTgl("dd-MM-yyyy"))
{
throw new ArgumentException("Tgl invalid");
}
// validasi jam
if (!model.Jam.IsValidJam("HH:mm:ss"))
{
throw new ArgumentException("Jam invalid");
}
// brg material
var brg = dep.BrgDal.GetData(model.BrgIDMaterial);
if (brg == null)
{
throw new ArgumentException("Brg Material invalid");
}
else
{
model.BrgNameMaterial = brg.BrgName;
}
// brg hasil
brg = dep.BrgDal.GetData(model.BrgIDHasil);
if (brg == null)
{
throw new ArgumentException("Brg Hasil invalid");
}
else
{
model.BrgNameHasil = brg.BrgName;
}
// validate qty nol
if (model.QtyMaterial <= 0)
{
throw new ArgumentException("Qty Material nol or minus");
}
if (model.QtyHasil <= 0)
{
throw new ArgumentException("Qty Hasil nol or minus");
}
using (var trans = TransHelper.NewScope())
{
if (model.RepackID.Trim() == "")
{
model.RepackID = GenNewID();
}
// delete data lama
dep.RepackDal.Delete(model.RepackID);
// simpan data baru
dep.RepackDal.Insert(model);
trans.Complete();
}
return(model);
}
