private void Save_Button_Click(object sender, EventArgs e)
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
}
List <VoucherCoverDetail> saveData = this.VoucherCoverDetailData
.Where(o => (o.SEQ ?? 0) > 0 && (o.Status == ModifyMode.Insert || o.Status == ModifyMode.Update)).ToList();
if (VoucherCoverDetailDeleteData != null && VoucherCoverDetailDeleteData.Count > 0)
{
saveData?.InsertRange(0, VoucherCoverDetailDeleteData);
}
if (saveData?.Count > 0)
{
using (VoucherCoverController controller = new VoucherCoverController())
{
if (controller.SaveVoucherCoverDetail(saveData))
{
MessageBoxHelper.ShowInfoMessage(BSMessage.BSM000001);
VoucherCoverDetailDeleteData = new List <VoucherCoverDetail>();
this.LoadGridData();
}
else
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000002);
}
}
}
}
private void UpdateVoucherCover()
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
return;
}
var frm = new InputBox()
{
Text = "Sửa tiêu đề",
Content = selected.VoucherCoverName
};
if (frm.ShowDialog() == DialogResult.OK)
{
selected.VoucherCoverName = frm.Content;
selected.Status = ModifyMode.Update;
if (SaveVoucherCover(selected))
{
MessageBoxHelper.ShowInfoMessage(BSMessage.BSM000001);
InitComboBox();
}
else
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000002);
}
}
}
private void Insert_Button_Click(object sender, EventArgs e)
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
return;
}
VoucherCoverDetail detailSelected = Detail_GridView.GetFocusedRow().CastTo <VoucherCoverDetail>();
if (detailSelected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
return;
}
int index = VoucherCoverDetailData.FindIndex(o => o.VoucherCoverID == selected.VoucherCoverID && o.SEQ == detailSelected.SEQ);
if (index < 0)
{
index = 0;
}
VoucherCoverDetailData.Insert(index, new VoucherCoverDetail
{
VoucherCoverID = selected.VoucherCoverID,
Status = ModifyMode.Insert
});
SetSEQ();
Detail_GridView.RefreshData();
Detail_GridView.FocusedRowHandle = index;
}
private bool SaveVoucherCover(VoucherCover data)
{
using (var controller = new VoucherCoverController())
{
return(controller.SaveVoucherCover(data));
}
}
private void AddNewVoucherCover()
{
var frm = new InputBox()
{
Text = "Thêm mới tiêu đề"
};
if (frm.ShowDialog() == DialogResult.OK)
{
var data = new VoucherCover
{
Status = ModifyMode.Insert,
VoucherCoverName = frm.Content
};
if (SaveVoucherCover(data))
{
MessageBoxHelper.ShowInfoMessage(BSMessage.BSM000001);
InitComboBox();
VoucherCover_LookupEdit.EditValue = data.VoucherCoverID;
}
else
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000002);
}
}
}
public bool DeleteVoucherCover(VoucherCover data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@VoucherCoverID", data.VoucherCoverID)
};
this.Context.ExecuteDataFromProcedure("VoucherCoverDelete", sqlParameters);
return(true);
}
private void Delete_Button_Click(object sender, EventArgs e)
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
return;
}
Detail_GridView.DeleteSelectedRows();
SetSEQ();
}
public bool UpdateVoucherCover(VoucherCover data)
{
SqlParameter[] sqlParameters = new SqlParameter[]
{
new SqlParameter("@VoucherCoverID", data.VoucherCoverID),
new SqlParameter("@VoucherCoverName", data.VoucherCoverName),
new SqlParameter("@CompanyID", CommonInfo.CompanyInfo.CompanyID),
new SqlParameter("@UpdateUser", UserInfo.UserID)
};
this.Context.ExecuteDataFromProcedure("VoucherCoverUpdate", sqlParameters);
return(true);
}
private void SetSEQ()
{
if (STTAuto_CheckEdit.Checked)
{
int seq = 0;
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
for (int i = 0; i < VoucherCoverDetailData.Count; i++)
{
if (VoucherCoverDetailData[i].VoucherCoverID == selected.VoucherCoverID)
{
seq++;
VoucherCoverDetailData[i].SEQ = seq;
}
}
}
}
private void DeleteVoucherCover()
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
selected.Status = ModifyMode.Delete;
if (SaveVoucherCover(selected))
{
MessageBoxHelper.ShowInfoMessage(BSMessage.BSM000001);
InitComboBox();
}
else
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000002);
}
}
private List <VoucherCoverDetail> GetSelectedDetailData()
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null || VoucherCoverDetailData == null)
{
return(null);
}
List <VoucherCoverDetail> result = VoucherCoverDetailData
.Where(o => o.VoucherCoverID == selected.VoucherCoverID).ToList();
result.ForEach(o => o.VoucherCoverName = selected.VoucherCoverName);
return(result);
}
private void SetFilterDetail()
{
this.Detail_GridView.ClearColumnsFilter();
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
return;
}
if (!string.IsNullOrEmpty(selected.VoucherCoverID))
{
//Set new filter
string filter = string.Empty;
filter += $"[VoucherCoverID] = '{selected.VoucherCoverID}'";
this.Detail_GridView.ActiveFilterString = filter;
}
}
private void Add_Button_Click(object sender, EventArgs e)
{
VoucherCover selected = VoucherCover_LookupEdit.GetSelectedDataRow().CastTo <VoucherCover>();
if (selected == null)
{
MessageBoxHelper.ShowErrorMessage(BSMessage.BSM000032);
return;
}
VoucherCoverDetailData.Add(new VoucherCoverDetail
{
VoucherCoverID = selected.VoucherCoverID,
Status = ModifyMode.Insert
});
SetSEQ();
Detail_GridView.RefreshData();
Detail_GridView.FocusedRowHandle = Detail_GridView.RowCount - 1;
}
public bool SaveVoucherCover(VoucherCover data)
{
using (DbContextTransaction transaction = Context.Database.BeginTransaction())
{
try
{
long seq = this.VoucherCoverDAO.GetVoucherCoverSEQ();
switch (data.Status)
{
// Add new
case ModifyMode.Insert:
seq++;
data.VoucherCoverID = GenerateID.VoucherCoverID(seq);
this.VoucherCoverDAO.InsertVoucherCover(data);
break;
// Update
case ModifyMode.Update:
this.VoucherCoverDAO.UpdateVoucherCover(data);
break;
// Delete
case ModifyMode.Delete:
this.VoucherCoverDAO.DeleteVoucherCover(data);
break;
}
transaction.Commit();
return(true);
}
catch (Exception ex)
{
transaction.Rollback();
BSLog.Logger.Error(ex.Message);
return(false);
}
}
}
public bool SaveVoucherCover(VoucherCover data)
{
return(this.VoucherCoverLogic.SaveVoucherCover(data));
}
