/// <summary>
/// Click event for Add buttom
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = (new Random(DateTime.Now.Millisecond)).Next(-999, 0).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = System.DateTime.Now;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
MemoDetail[] newMemoArray = new MemoDetail[this._BatchDetail.Memos.Length + 1];
Array.Copy(
this._BatchDetail.Memos,
0,
newMemoArray,
0,
this._BatchDetail.Memos.Length);
newMemoArray[this._BatchDetail.Memos.Length] = newMemoDetailForm.MemoDetail;
this.BatchDetail.Memos = newMemoArray;
this.UpdateMemoList();
}
}
public MemoDetail CreateMemo(string LotNos, int LoginID, int CustomerID, int isConfirmed, int isSellDirect, string Remark)
{
try
{
MemoDetail objMD = new MemoDetail();
var cmd = context.Database.Connection.CreateCommand();
cmd.CommandText = "exec proc_inventoryMemo 0,'" + LotNos + "'," +
LoginID.ToString() + "," + CustomerID.ToString() + "," +
isConfirmed.ToString() + "," + isSellDirect + ",0,0,'" +
Remark + "','putOnMemo'";
context.Database.Connection.Open();
// Run the sproc
var reader = cmd.ExecuteReader();
objMD.Inv = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <InventoryUpload>(reader).ToList();
reader.NextResult();
objMD.Counts = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <PlaceOrderViewModel>(reader).FirstOrDefault();
return(objMD);
}
finally
{
context.Database.Connection.Close();
}
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="memoDetail">MemoDetail, memo to be displayed in form</param>
/// <param name="formState">FormState, describing the current form state</param>
public MemoDetailForm(MemoDetail memoDetail, FormState formState)
: this()
{
this.MemoDetail = memoDetail;
this.originalMemoXML = TestController.SerializeXML(memoDetail, false);
this.SetFormState(formState);
switch (formState)
{
case FormState.NewMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.NewMemo;
break;
}
case FormState.ViewMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.ViewMemo;
break;
}
case FormState.EditMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.EditMemo;
break;
}
}
}
/// <summary>
/// Constructor
/// </summary>
/// <param name="memoDetail">MemoDetail, memo to be displayed in form</param>
/// <param name="formState">FormState, describing the current form state</param>
public MemoDetailForm(MemoDetail memoDetail, FormState formState) : this()
{
this.MemoDetail = memoDetail;
this.originalMemoXML = TestController.SerializeXML(memoDetail, false);
this.SetFormState(formState);
switch (formState)
{
case FormState.NewMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.NewMemo;
break;
}
case FormState.ViewMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.ViewMemo;
break;
}
case FormState.EditMemo:
{
this.ctrlMemoDetail.CurrentMemostate = MemoDetailControl.MemoState.EditMemo;
break;
}
}
}
private void EditMemo()
{
MemoDetail selectedMemo = (MemoDetail)lstMemos.SelectedItem;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(selectedMemo, MemoDetailForm.FormState.EditMemo);
newMemoDetailForm.ShowDialog();
}
/// <summary>
/// Click event for Cancel button
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnCancel_Click(object sender, EventArgs e)
{
if (this.MemoFormState == FormState.EditMemo)
{
// set object back to original values
MemoDetail originalMemo = TestController.DeserializeXML <MemoDetail>(this.originalMemoXML, false);
this.MemoDetail.Memo = originalMemo.Memo;
this.MemoDetail.Type = originalMemo.Type;
}
this.DialogResult = System.Windows.Forms.DialogResult.Cancel;
}
public MemoDetailViewModel(int ser, MemoViewModel memo)
{
MemoDetail = new MemoDetail();
PaymentDetails = new ObservableCollection <PaymentDetail>(MemoDetail.PaymentDetails);
var paymenttypes = memo.PaymentTypes;
foreach (var paymenttype in paymenttypes)
{
account(paymenttype.Account, ser);
}
}
public ActionResult PartialCancel(int OrderID, string LotNos, int FileNo = 0)
{
try
{
int LoginID = GetLogin();
if (LoginID > 0)
{
OrderInfoViewModel objInfo = this.objMemoService.MemoInfo(OrderID);
MemoDetail obj = this.objMemoService.CancelPartialMemo(OrderID, LotNos, LoginID);
if (FileNo != 0)
{
fileUploadLogModel objFile = this.objMemoService.GetFileByID(FileNo);
if (objFile != null)
{
String path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["INVUpload"]);
DataTable dtValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "Valid").ToList());
DataTable dtNotValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "InValid").ToList());
ExportToExcel.SaveExcel(path, FileNo.ToString() + "_Valid", "Valid", dtValid);
ExportToExcel.SaveExcel(path, FileNo.ToString() + "_InValid", "InValid", dtNotValid);
objFile.validInv = obj.Inv.Where(x => x.LotStatus == "Valid").Count();
objFile.invalidInv = obj.Inv.Where(x => x.LotStatus == "InValid").Count();
this.objMemoService.UpdateFile(objFile);
if (obj.Counts.OrderId > 0)
{
this.objMemoService.UpdateFile(obj.Counts.OrderId, FileNo);
}
}
}
if (objInfo != null && obj.Counts != null && obj.Counts.OrderId > 0)
{
this.objMemoService.SendMailMemo(obj.Counts.OrderId, GetEmailID(), GetFullName(), objInfo.UserDetail.loginID, "List of inventory Partial Canceled Memo from memo-", "", Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["EmailTemplate_CancelMemo"]), objInfo, LotNos);
bool log = this.objUDSvc.UserActivitylogs(LoginID, "Partial canceled memo", LotNos);
}
return(Json(new Response {
Code = 200, IsSuccess = true, Message = "", Result = obj.Counts.validCount
}));
}
return(Json(new Response {
IsSuccess = false, Message = string.Format(StringResource.Invalid, "Session")
}));
}
catch (Exception ex)
{
ErrorLog.Log("MemoController", "PartialCancel", ex);
return(Json(new Response {
IsSuccess = false, Message = ex.Message
}));
}
}
/// <summary>
/// Delete selected memo
/// </summary>
private void DeleteSelectedMemo()
{
MemoDetail selectedMemo = (MemoDetail)lstMemos.SelectedItem;
if (selectedMemo.ActionCode == ActionCode.New)
{
this.CurrentMemos.Remove(selectedMemo);
this._DocumentInfo.Memos = this.CurrentMemos.ToArray();
}
else
{
selectedMemo.ActionCode = ActionCode.Delete;
}
this.UpdateMemosList();
}
public ActionResult Book(string LotNos, int CustomerID, int isConfirmed, int isSellDirect, string Remark, int FileNo = 0)
{
try
{
int LoginID = GetLogin();
if (LoginID > 0)
{
MemoDetail obj = this.objMemoService.CreateMemo(LotNos, LoginID, CustomerID, isConfirmed, isSellDirect, Remark);
if (FileNo != 0)
{
fileUploadLogModel objFile = this.objMemoService.GetFileByID(FileNo);
if (objFile != null)
{
String path = Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["INVUpload"]);
DataTable dtValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "Valid").ToList());
DataTable dtNotValid = ListtoDataTable.ToDataTable <InventoryUpload>(obj.Inv.Where(x => x.LotStatus == "InValid").ToList());
ExportToExcel.SaveExcel(path, FileNo.ToString() + "_Valid", "Valid", dtValid);
ExportToExcel.SaveExcel(path, FileNo.ToString() + "_InValid", "InValid", dtNotValid);
objFile.validInv = obj.Inv.Where(x => x.LotStatus == "Valid").Count();
objFile.invalidInv = obj.Inv.Where(x => x.LotStatus == "InValid").Count();
this.objMemoService.UpdateFile(objFile);
if (obj.Counts.OrderId > 0)
{
this.objMemoService.UpdateFile(obj.Counts.OrderId, FileNo);
}
}
}
if (obj != null && obj.Counts.OrderId != 0)
{
this.objMemoService.SendMailMemo(obj.Counts.OrderId, GetEmailID(), GetFullName(), CustomerID, "List of inventory put on memo to", "", Server.MapPath(System.Configuration.ConfigurationManager.AppSettings["EmailTemplate_PutOnMemo"]));
bool log = this.objUDSvc.UserActivitylogs(LoginID, "Put on memo", LotNos);
}
return(Json(new Response {
Code = 200, IsSuccess = true, Message = "", Result = obj.Counts
}));
}
return(Json(new Response {
IsSuccess = false, Message = string.Format(StringResource.Invalid, "Session")
}));
}
catch (Exception ex)
{
ErrorLog.Log("MemoController", "Book", ex);
return(Json(new Response {
IsSuccess = false, Message = ex.Message
}));
}
}
/// <summary>
/// Add Memo
/// </summary>
private void AddMemo()
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = "-" + (new Random(DateTime.Now.Millisecond)).Next(1, 1000).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = newMemo.CreateTimeStamp;
newMemo.Type = MemoTypes.Note;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
this._DocumentInfo.ActionCode = this._DocumentInfo.ActionCode == ActionCode.New ? ActionCode.New : ActionCode.Edit;
this.CurrentMemos.Add(newMemo);
this._DocumentInfo.Memos = CurrentMemos.ToArray();
this.UpdateMemosList();
}
}
/// <summary>
/// Double Click method for ListBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstMemos_DoubleClick(object sender, EventArgs e)
{
if (this._allowEdit)
{
if (this.lstMemos.SelectedItem == null)
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = (new Random(DateTime.Now.Millisecond)).Next(-999, 0).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = newMemo.CreateTimeStamp;
newMemo.Type = MemoTypes.Note;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
MemoDetail[] newMemoArray = new MemoDetail[this._BatchDetail.Memos.Length + 1];
Array.Copy(this._BatchDetail.Memos, 0, newMemoArray, 0, this._BatchDetail.Memos.Length);
newMemoArray[this._BatchDetail.Memos.Length] = newMemoDetailForm.MemoDetail;
this.BatchDetail.Memos = newMemoArray;
this.UpdateMemoList();
}
}
else
{
MemoDetail selectedMemo = this._BatchDetail.Memos[this.lstMemos.SelectedIndex];
MemoDetailForm newMemoDetailForm = new MemoDetailForm(selectedMemo, MemoDetailForm.FormState.EditMemo);
newMemoDetailForm.ShowDialog(this);
}
}
else
{
if (this.lstMemos.SelectedItem != null)
{
MemoDetail selectedMemo = this._BatchDetail.Memos[this.lstMemos.SelectedIndex];
MemoDetailForm newMemoDetailForm = new MemoDetailForm(selectedMemo, MemoDetailForm.FormState.ViewMemo);
newMemoDetailForm.ShowDialog(this);
}
}
}
public MemoDetail CancelPartialMemo(int OrderID, string LotNos, int LoginID)
{
try
{
MemoDetail objMD = new MemoDetail();
//int RowCount = 0;
context.Database.Connection.Open();
int CustomerID = this.context.orderDetails.Where(x => x.orderDetailsId == OrderID).Select(x => x.customerId).FirstOrDefault();
var cmd = context.Database.Connection.CreateCommand();
cmd.CommandText = "exec proc_inventoryMemo " + OrderID.ToString() + ",'" + LotNos + "'," +
LoginID.ToString() + "," + CustomerID.ToString() + ",0,0,0,0,'','cancelPartialMemo'";
//// Run the sproc
//var reader = cmd.ExecuteReader();
//// Read OrderDetail from the first result set
//RowCount = ((IObjectContextAdapter)context)
// .ObjectContext
// .Translate<int>(reader).FirstOrDefault();
//return RowCount;
var reader = cmd.ExecuteReader();
objMD.Inv = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <InventoryUpload>(reader).ToList();
reader.NextResult();
objMD.Counts = ((IObjectContextAdapter)context)
.ObjectContext
.Translate <PlaceOrderViewModel>(reader).FirstOrDefault();
return(objMD);
}
finally
{
context.Database.Connection.Close();
}
}
public void Shoul_Success_Build_MemoDetail()
{
var vm = new MemoDetail()
{
BillsNo = "BillsNo",
CurrencyCode = "Code",
GarmentDeliveryOrderId = 1,
GarmentDeliveryOrderNo = "DONo",
InternalNoteNo = "INNo",
MemoAmount = 1,
MemoIdrAmount = 1,
PaymentBills = "Bills",
PaymentRate = 1,
PurchaseAmount = 1,
PurchasingRate = 1,
RemarksDetail = "Remarlks",
SupplierCode = "Code",
SupplierName = "Name"
};
Assert.NotNull(vm);
}
/// <summary>
/// Double Click method for ListBox
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void lstMemos_DoubleClick(object sender, EventArgs e)
{
if (this._allowEdit)
{
if (this.lstMemos.SelectedItem == null)
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = (new Random(DateTime.Now.Millisecond)).Next(-999, 0).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = newMemo.CreateTimeStamp;
newMemo.Type = MemoTypes.Note;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
MemoDetail[] newMemoArray = new MemoDetail[this._BatchDetail.Memos.Length + 1];
Array.Copy(this._BatchDetail.Memos, 0, newMemoArray, 0, this._BatchDetail.Memos.Length);
newMemoArray[this._BatchDetail.Memos.Length] = newMemoDetailForm.MemoDetail;
this.BatchDetail.Memos = newMemoArray;
this.UpdateMemoList();
}
}
else
{
MemoDetail selectedMemo = this._BatchDetail.Memos[this.lstMemos.SelectedIndex];
MemoDetailForm newMemoDetailForm = new MemoDetailForm(selectedMemo, MemoDetailForm.FormState.EditMemo);
newMemoDetailForm.ShowDialog(this);
}
}
else
{
if (this.lstMemos.SelectedItem != null)
{
MemoDetail selectedMemo = this._BatchDetail.Memos[this.lstMemos.SelectedIndex];
MemoDetailForm newMemoDetailForm = new MemoDetailForm(selectedMemo, MemoDetailForm.FormState.ViewMemo);
newMemoDetailForm.ShowDialog(this);
}
}
}
/// <summary>
/// Click event for Add buttom
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = (new Random(DateTime.Now.Millisecond)).Next(-999, 0).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = System.DateTime.Now;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
MemoDetail[] newMemoArray = new MemoDetail[this._BatchDetail.Memos.Length + 1];
Array.Copy(
this._BatchDetail.Memos,
0,
newMemoArray,
0,
this._BatchDetail.Memos.Length);
newMemoArray[this._BatchDetail.Memos.Length] = newMemoDetailForm.MemoDetail;
this.BatchDetail.Memos = newMemoArray;
this.UpdateMemoList();
}
}
public ReportMemoDetailVM(MemoDetail memoD)
{
memoDetail = memoD;
Description = memoDetail.Service.ServiceName;
}
/// <summary>
/// Add Memo
/// </summary>
private void AddMemo()
{
MemoDetail newMemo = new MemoDetail();
newMemo._ID = "-" + (new Random(DateTime.Now.Millisecond)).Next(1, 1000).ToString();
newMemo.CreateTimeStamp = System.DateTime.Now;
newMemo.EditTimeStamp = newMemo.CreateTimeStamp;
newMemo.Type = MemoTypes.Note;
newMemo.ActionCode = ActionCode.New;
MemoDetailForm newMemoDetailForm = new MemoDetailForm(newMemo, MemoDetailForm.FormState.NewMemo);
if (newMemoDetailForm.ShowDialog(this) == DialogResult.OK)
{
this._DocumentInfo.ActionCode = this._DocumentInfo.ActionCode == ActionCode.New ? ActionCode.New : ActionCode.Edit;
this.CurrentMemos.Add(newMemo);
this._DocumentInfo.Memos = CurrentMemos.ToArray();
this.UpdateMemosList();
}
}
