public DTO.SearchFormData GetDataWithFilter(int iRequesterID, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
// keep log entry
fwBLL.WriteLog(iRequesterID, 0, "get list of Purchasing Invoice");
// query data
return(factory.GetDataWithFilter(filters, pageSize, pageIndex, orderBy, orderDirection, out totalRows, out notification));
}
public override IEnumerable <DTO.WarehouseCIMng.WarehouseCISearch> GetDataWithFilter(int iRequesterID, Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
// keep log entry
fwBLL.WriteLog(iRequesterID, 0, "get list of warehouse ci");
return(factory.GetDataWithFilter(filters, pageSize, pageIndex, orderBy, orderDirection, out totalRows, out notification));
}
public override bool DeleteData(int id, int iRequesterID, out Library.DTO.Notification notification)
{
// keep log entry
fwBLL.WriteLog(iRequesterID, 0, "delete warehouse ci " + id.ToString());
return(factory.DeleteData(id, out notification));
}
public bool DeleteData(int userId, int id, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
//return bll.DeleteData(userId, id, out notification);
}
public object GetInitData(int userId, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
//return bll.GetInitData(userId, out notification);
}
public override DTO.EditFormData GetData(int id, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public override bool Reset(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public DTO.ShippingInstructionMng.ShippingInstruction GetDefault(int clientId, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.ShippingInstructionMng.ShippingInstruction data = new DTO.ShippingInstructionMng.ShippingInstruction();
//try to get data
try
{
using (ShippingInstructionMngEntities context = CreateContext())
{
data = converter.DB2DTO_ShippingInstruction(context.ShippingInstructionMng_ShippingInstruction_View.FirstOrDefault(o => o.ClientID == clientId && o.IsDefault.HasValue && o.IsDefault.Value));
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public DTO.ShippingInstructionMng.PODCountry GetCountryFromPODfunction(int podid, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.ShippingInstructionMng.PODCountry data = new DTO.ShippingInstructionMng.PODCountry();
//try to get data
try
{
using (ShippingInstructionMngEntities context = CreateContext())
{
data = converter.DB2DTO_PODCountry(context.ShippingInstructionMng_PODCountry_View.FirstOrDefault(o => o.PoDID == podid));
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public override bool UpdateData(int id, ref DTO.ShippingInstructionMng.ShippingInstruction dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (ShippingInstructionMngEntities context = CreateContext())
{
ShippingInstruction dbItem = null;
if (id == 0)
{
dbItem = new ShippingInstruction();
context.ShippingInstruction.Add(dbItem);
}
else
{
dbItem = context.ShippingInstruction.FirstOrDefault(o => o.ShippingInstructionID == id);
}
if (dbItem == null)
{
notification.Message = "Shipping instruction not found!";
return(false);
}
else
{
// check concurrency
if (dbItem.ConcurrencyFlag != null && !dbItem.ConcurrencyFlag.SequenceEqual(Convert.FromBase64String(dtoItem.ConcurrencyFlag_String)))
{
throw new Exception(DALBase.Helper.TEXT_CONCURRENCY_CONFLICT);
}
// reset default
if (dtoItem.IsDefault.HasValue && dtoItem.IsDefault.Value)
{
int ClientID = dtoItem.ClientID.Value;
List <int> InstructionIDs = context.ShippingInstructionMng_ShippingInstruction_View.Where(o => o.ClientID == ClientID).Select(o => o.ShippingInstructionID).ToList();
context.ShippingInstruction.Where(o => InstructionIDs.Contains(o.ShippingInstructionID)).ToList().ForEach(o => o.IsDefault = null);
}
converter.DTO2DB(dtoItem, ref dbItem);
context.SaveChanges();
dtoItem = GetData(dbItem.ShippingInstructionID, out notification).Data;
return(true);
}
}
}
catch (Exception ex)
{
notification = new Library.DTO.Notification()
{
Message = ex.Message, Type = Library.DTO.NotificationType.Error
};
return(false);
}
}
public override bool Reset(int id, ref DTO.ShippingInstructionMng.ShippingInstruction dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
try
{
using (ShippingInstructionMngEntities context = CreateContext())
{
ShippingInstruction dbItem = context.ShippingInstruction.FirstOrDefault(o => o.ShippingInstructionID == id);
if (dbItem != null)
{
dbItem.IsConfirmed = false;
dbItem.ConfirmedBy = null;
dbItem.ConfirmedDate = null;
dbItem.UpdatedBy = dtoItem.UpdatedBy;
dbItem.UpdatedDate = DateTime.Now;
context.SaveChanges();
dtoItem = GetData(id, out notification).Data;
return(true);
}
else
{
throw new Exception("Shipping instruction not found!");
}
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
return(false);
}
}
public override DTO.ShippingInstructionMng.SearchFormData GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
DTO.ShippingInstructionMng.SearchFormData data = new DTO.ShippingInstructionMng.SearchFormData();
data.Data = new List <DTO.ShippingInstructionMng.ShippingInstructionSearchResult>();
totalRows = 0;
//try to get data
try
{
using (ShippingInstructionMngEntities context = CreateContext())
{
string ClientUD = null;
string ProformaInvoiceNo = null;
string Priority = null;
int? PODID = null;
bool? IsDefault = null;
bool? IsSample = null;
if (filters.ContainsKey("ClientUD") && !string.IsNullOrEmpty(filters["ClientUD"].ToString()))
{
ClientUD = filters["ClientUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("ProformaInvoiceNo") && !string.IsNullOrEmpty(filters["ProformaInvoiceNo"].ToString()))
{
ProformaInvoiceNo = filters["ProformaInvoiceNo"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("PODID") && !string.IsNullOrEmpty(filters["PODID"].ToString()))
{
PODID = (int)filters["PODID"];
}
if (filters.ContainsKey("Priority") && !string.IsNullOrEmpty(filters["Priority"].ToString()))
{
Priority = filters["Priority"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("IsDefault") && !string.IsNullOrEmpty(filters["IsDefault"].ToString()))
{
if (filters["IsDefault"].ToString() == "1")
{
IsDefault = true;
}
else
{
IsDefault = false;
}
}
if (filters.ContainsKey("IsSample") && !string.IsNullOrEmpty(filters["IsSample"].ToString()))
{
if (filters["IsSample"].ToString() == "1")
{
IsSample = true;
}
else
{
IsSample = false;
}
}
totalRows = context.ShippingInstructionMng_function_SearchShippingInstruction(ClientUD, PODID, ProformaInvoiceNo, Priority, IsDefault, IsSample, orderBy, orderDirection).Count();
var result = context.ShippingInstructionMng_function_SearchShippingInstruction(ClientUD, PODID, ProformaInvoiceNo, Priority, IsDefault, IsSample, orderBy, orderDirection);
data.Data = converter.DB2DTO_ShippingInstructionSearchResultList(result.Skip(pageSize * (pageIndex - 1)).Take(pageSize).ToList());
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
}
return(data);
}
public DTO.SearchFilterData GetSearchFilter(out Library.DTO.Notification notification)
{
return(factory.GetSearchFilter(out notification));
}
public bool Reset(int iRequesterID, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public bool UpdateData(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.FactoryLocation factoryLocation = ((Newtonsoft.Json.Linq.JObject)dtoItem).ToObject <DTO.FactoryLocation>();
bool resultUpdate = false;
// Check location code is null.
if (string.IsNullOrEmpty(factoryLocation.LocationUD.Trim()))
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Please input Location Code!";
return(resultUpdate);
}
try
{
using (var context = CreateContext())
{
Location location = null;
if (id < 0)
{
// Check location code exist.
location = context.Location.FirstOrDefault(o => o.LocationUD == factoryLocation.LocationUD);
if (location != null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Location already in database!";
return(resultUpdate);
}
else
{
location = new Location();
}
context.Location.Add(location);
}
else
{
location = context.Location.FirstOrDefault(o => o.LocationID == id);
if (location == null)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = "Cannot found data!";
return(resultUpdate);
}
}
converter.DTO2DB_UpdateData(factoryLocation, ref location);
if (id < 0)
{
location.CreatedBy = userId;
location.CreatedDate = DateTime.Now;
}
location.UpdatedBy = userId;
location.UpdatedDate = DateTime.Now;
location.LocationUD = factoryLocation.LocationUD;
context.SaveChanges();
dtoItem = converter.DB2DTO_FactoryLocation(context.FactoryLocationMng_Location_View.FirstOrDefault(o => o.LocationID == location.LocationID));
resultUpdate = true;
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
}
return(resultUpdate);
}
public string ExportExcel(System.Collections.Hashtable filters, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
ShippingInstructionMngObject ds = new ShippingInstructionMngObject();
string ClientUD = null;
string ProformaInvoiceNo = null;
string Priority = null;
int? PODID = null;
bool? IsDefault = null;
bool? IsSample = null;
if (filters.ContainsKey("ClientUD") && !string.IsNullOrEmpty(filters["ClientUD"].ToString()))
{
ClientUD = filters["ClientUD"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("ProformaInvoiceNo") && !string.IsNullOrEmpty(filters["ProformaInvoiceNo"].ToString()))
{
ProformaInvoiceNo = filters["ProformaInvoiceNo"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("PODID") && !string.IsNullOrEmpty(filters["PODID"].ToString()))
{
PODID = (int)filters["PODID"];
}
if (filters.ContainsKey("Priority") && !string.IsNullOrEmpty(filters["Priority"].ToString()))
{
Priority = filters["Priority"].ToString().Replace("'", "''");
}
if (filters.ContainsKey("IsDefault") && !string.IsNullOrEmpty(filters["IsDefault"].ToString()))
{
if (filters["IsDefault"].ToString() == "1")
{
IsDefault = true;
}
else
{
IsDefault = false;
}
}
if (filters.ContainsKey("IsSample") && !string.IsNullOrEmpty(filters["IsSample"].ToString()))
{
if (filters["IsSample"].ToString() == "1")
{
IsSample = true;
}
else
{
IsSample = false;
}
}
try
{
System.Data.SqlClient.SqlDataAdapter adap = new System.Data.SqlClient.SqlDataAdapter();
adap.SelectCommand = new System.Data.SqlClient.SqlCommand("ShippingInstructionMng_Function_ExportExcelWithFilter", new System.Data.SqlClient.SqlConnection(DALBase.Helper.GetSQLConnectionString()));
adap.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
adap.SelectCommand.Parameters.AddWithValue("ClientUD", ClientUD);
adap.SelectCommand.Parameters.AddWithValue("ProformaInvoiceNo", ProformaInvoiceNo);
adap.SelectCommand.Parameters.AddWithValue("Priority", Priority);
adap.SelectCommand.Parameters.AddWithValue("IsDefault", IsDefault);
adap.SelectCommand.Parameters.AddWithValue("IsSample", IsSample);
adap.TableMappings.Add("Table", "ShippingInstructionMng_ShippingInstructionExportExcel_View");
adap.Fill(ds);
ds.AcceptChanges();
return(Library.Helper.CreateReportFileWithEPPlus(ds, "ShippingInstructionRpt"));
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
return(string.Empty);
}
}
public override DTO.SearchFormData GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public object GetDataWithFilter(int userId, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public override bool DeleteData(int id, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public object GetData(int userId, int id, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public object GetDataWithFilter(int userId, System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
return(bll.GetDataWithFilter(userId, filters, pageSize, pageIndex, orderBy, orderDirection, out totalRows, out notification));
}
public bool Approve(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
}
public bool Reset(int userId, int id, ref object dtoItem, out Library.DTO.Notification notification)
{
throw new NotImplementedException();
//return bll.Reset(userId, id, ref dtoItem, out notification);
}
public object GetInitData(int userId, out Library.DTO.Notification notification)
{
return(bll.GetInitData(userId, out notification));
}
public object CustomFunction(int userId, string identifier, System.Collections.Hashtable filters, out Library.DTO.Notification notification)
{
switch (identifier.ToLower())
{
case "getdeliverynotelist":
return(bll.GetDetailProductionItemList(userId, filters, out notification));
case "getdeliverynoteprintouthtml":
return(bll.GetDeliveryNotePrintoutHTML(userId, filters, out notification));
}
notification = new Library.DTO.Notification {
Type = Library.DTO.NotificationType.Error, Message = "Custom function's identifier not matched"
};
return(null);
}
public object CustomFunction(int userId, string identifier, System.Collections.Hashtable input, out Library.DTO.Notification notification)
{
notification = new Library.DTO.Notification()
{
Type = Library.DTO.NotificationType.Success
};
switch (identifier.Trim().ToLower())
{
case "getexcelreport":
if (input.ContainsKey("Season"))
{
return(bll.GetExcelReportData(userId, input["Season"].ToString(), out notification));
}
else
{
notification.Message = "unknow season";
notification.Type = Library.DTO.NotificationType.Error;
}
break;
case "gethtmlreport":
if (input.ContainsKey("Season"))
{
return(bll.GetHtmlReportData(userId, input["Season"].ToString(), out notification));
}
else
{
notification.Message = "unknow season";
notification.Type = Library.DTO.NotificationType.Error;
}
break;
case "get-admin-dashboard":
if (input.ContainsKey("season"))
{
return(bll.GetSalePerformance(userId, input["season"].ToString(), out notification));
}
else
{
notification.Message = "unknow season";
notification.Type = Library.DTO.NotificationType.Error;
}
break;
default:
notification.Message = "function identifier do not match";
notification.Type = Library.DTO.NotificationType.Error;
break;
}
return(null);
}
public override DTO.WarehouseCIMng.WarehouseCI GetData(int id, int iRequesterID, out Library.DTO.Notification notification)
{
// keep log entry
fwBLL.WriteLog(iRequesterID, 0, "get warehouse ci " + id.ToString());
return(factory.GetData(id, out notification));
}
public DTO.SearchForm GetDataWithFilter(System.Collections.Hashtable filters, int pageSize, int pageIndex, string orderBy, string orderDirection, out int totalRows, out Library.DTO.Notification notification)
{
totalRows = 0;
notification = new Library.DTO.Notification();
notification.Type = Library.DTO.NotificationType.Success;
DTO.SearchForm data = new DTO.SearchForm();
data.FactoryLocations = new List <DTO.FactoryLocation>();
try
{
using (var context = CreateContext())
{
string locationUD = filters.ContainsKey("locationUD") && filters["locationUD"] != null && !string.IsNullOrEmpty(filters["locationUD"].ToString().Replace("'", "''")) ? filters["locationUD"].ToString().Trim() : null;
string locationNM = filters.ContainsKey("locationNM") && filters["locationNM"] != null && !string.IsNullOrEmpty(filters["locationNM"].ToString().Replace("'", "''")) ? filters["locationNM"].ToString().Trim() : null;
int? manufacturerCountryID = filters.ContainsKey("manufacturerCountryID") && filters["manufacturerCountryID"] != null && !string.IsNullOrEmpty(filters["manufacturerCountryID"].ToString().Replace("'", "''")) ? (int?)Convert.ToInt32(filters["manufacturerCountryID"].ToString().Trim()) : null;
totalRows = context.FactoryLocationMng_function_LocationSearchResult(locationUD, locationNM, manufacturerCountryID, orderBy, orderDirection).Count();
data.FactoryLocations = converter.DB2DTO_FactoryLocationSearchResult(context.FactoryLocationMng_function_LocationSearchResult(locationUD, locationNM, manufacturerCountryID, orderBy, orderDirection).ToList());
}
}
catch (Exception ex)
{
notification.Type = Library.DTO.NotificationType.Error;
notification.Message = ex.Message;
if (ex.InnerException != null && !string.IsNullOrEmpty(ex.InnerException.Message))
{
notification.DetailMessage.Add(ex.InnerException.Message);
}
}
return(data);
}
public override bool UpdateData(int id, ref DTO.WarehouseCIMng.WarehouseCI dtoItem, int iRequesterID, out Library.DTO.Notification notification)
{
// keep log entry
fwBLL.WriteLog(iRequesterID, 0, "update warehouse ci " + id.ToString());
dtoItem.UpdatedBy = iRequesterID;
return(factory.UpdateData(id, ref dtoItem, out notification));
}
public bool CreateReturnData(object dtoItem, out Library.DTO.Notification notification)
{
DAL.DataFactoryReturnGoods factory = new DAL.DataFactoryReturnGoods();
return(factory.CreateReturnData(dtoItem, out notification));
}
