/// <summary>
/// Update record by using the table's primary key.
/// </summary>
/// <param name="database"></param>
/// <param name="data">Data which to update.</param>
/// <param name="oldSCREEN_CD">Old Key #1</param>
/// <param name="oldLANG_CD">Old Key #2</param>
/// <returns></returns>
public int UpdateWithPK(Database database, ScreenLangDTO data, NZString oldSCREEN_CD, NZString oldLANG_CD)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" UPDATE " + data.TableName);
sb.AppendLine(" SET ");
sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD + "=:SCREEN_CD");
sb.AppendLine(" ," + ScreenLangDTO.eColumns.LANG_CD + "=:LANG_CD");
sb.AppendLine(" ," + ScreenLangDTO.eColumns.SCREEN_DESC + "=:SCREEN_DESC");
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_BY + "=:UPD_BY");
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_DATE + "=GETDATE()");
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_MACHINE + "=:UPD_MACHINE");
sb.AppendLine(" WHERE ");
sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD + "=:oldSCREEN_CD");
sb.AppendLine(" AND " + ScreenLangDTO.eColumns.LANG_CD + "=:oldScreenLang");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value);
req.Parameters.Add("SCREEN_DESC", DataType.NVarChar, data.SCREEN_DESC.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
req.Parameters.Add("oldSCREEN_CD", DataType.VarChar, oldSCREEN_CD.Value);
req.Parameters.Add("oldLANG_CD", DataType.VarChar, oldLANG_CD.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
/// <summary>
/// Check exist before manipulate data. If found record will update data. Otherwise insert new data.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNewOrUpdate(Database database, ScreenLangDTO data)
{
Database db = UseDatabase(database);
if (Exist(database, data.SCREEN_CD, data.LANG_CD))
{
return(UpdateWithoutPK(db, data));
}
return(AddNew(db, data));
}
internal int SaveScreenDisplayText(string ScreenCD, string LangCD, string DisplayTitle)
{
ScreenLangBIZ biz = new ScreenLangBIZ();
ScreenLangDTO dto = new ScreenLangDTO();
dto.SCREEN_CD.Value = ScreenCD;
dto.LANG_CD.Value = LangCD;
dto.SCREEN_DESC.Value = DisplayTitle;
dto.UPD_BY.Value = CommonLib.Common.CurrentUserInfomation.UserCD.StrongValue;
dto.UPD_DATE.Value = DateTime.Now;
dto.UPD_MACHINE.Value = Environment.MachineName;
return(biz.UpdateScreenDisplayText(dto));
}
/// <summary>
/// Insert new record into database.
/// </summary>
/// <param name="database"></param>
/// <param name="data"></param>
/// <returns></returns>
public int AddNew(Database database, ScreenLangDTO data)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
#region SQL Statement
sb.AppendLine(" INSERT INTO " + data.TableName + "(");
sb.AppendLine(" " + ScreenLangDTO.eColumns.SCREEN_CD);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.LANG_CD);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.SCREEN_DESC);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_BY);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_DATE);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.CRT_MACHINE);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_BY);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_DATE);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.UPD_MACHINE);
sb.AppendLine(" ," + ScreenLangDTO.eColumns.IS_USED);
sb.AppendLine(") VALUES(");
sb.AppendLine(" :SCREEN_CD");
sb.AppendLine(" ,:LANG_CD");
sb.AppendLine(" ,:SCREEN_DESC");
sb.AppendLine(" ,:CRT_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:CRT_MACHINE");
sb.AppendLine(" ,:UPD_BY");
sb.AppendLine(" ,GETDATE()");
sb.AppendLine(" ,:UPD_MACHINE");
sb.AppendLine(" ,1");
sb.AppendLine(" )");
#endregion
DataRequest req = new DataRequest(sb.ToString());
#region Parameters
req.Parameters.Add("SCREEN_CD", DataType.VarChar, data.SCREEN_CD.Value);
req.Parameters.Add("LANG_CD", DataType.VarChar, data.LANG_CD.Value);
req.Parameters.Add("SCREEN_DESC", DataType.NVarChar, data.SCREEN_DESC.Value);
req.Parameters.Add("CRT_BY", DataType.NVarChar, data.CRT_BY.Value);
req.Parameters.Add("CRT_MACHINE", DataType.NVarChar, data.CRT_MACHINE.Value);
req.Parameters.Add("UPD_BY", DataType.NVarChar, data.UPD_BY.Value);
req.Parameters.Add("UPD_MACHINE", DataType.NVarChar, data.UPD_MACHINE.Value);
#endregion
return(db.ExecuteNonQuery(req));
}
public void UpdateIsUsed(Database database, ScreenLangDTO argScreenLangDTO)
{
Database db = UseDatabase(database);
StringBuilder sb = new StringBuilder();
sb.AppendLine(" UPDATE TZ_SCREEN_LANG_MS ");
sb.AppendLine(" SET IS_USED = 1 ");
sb.AppendLine(" WHERE SCREEN_CD = :pSCREEN_CD");
sb.AppendLine(" AND LANG_CD = :pLANG_CD");
DataRequest req = new DataRequest(sb.ToString());
req.Parameters.Add("@pSCREEN_CD", argScreenLangDTO.SCREEN_CD.Value);
req.Parameters.Add("@pLANG_CD", argScreenLangDTO.LANG_CD.Value);
db.ExecuteNonQuery(req);
}
public void ImportData(List <ScreenImportUIDM> ScreenImportList, List <ScreenDetailUIDM> UIDMScreenDetailList)
{
LangBIZ bizLang = new LangBIZ();
LangDTO dtoLang = new LangDTO();
ScreenDetailBIZ bizScreenDetail = new ScreenDetailBIZ();
List <ScreenDTO> screenDTOList = new List <ScreenDTO>();
List <ScreenLangDTO> screenLangDTOList = new List <ScreenLangDTO>();
List <ScreenDetailDTO> screenDetailDTOList = new List <ScreenDetailDTO>();
List <ScreenDetailLangDTO> screenDetailLangDTOList = new List <ScreenDetailLangDTO>();
// count lang detail
List <LangDTO> langDTOList = bizLang.LoadAll();
#region Collect Data
foreach (ScreenImportUIDM ScreenImport in ScreenImportList)
{
// check if screen is never been import then import to screen ms
if (ScreenImport.ImportStatus.StrongValue.ToUpper() == "NOTIMPORT")
{
ScreenDTO dtoScreen = new ScreenDTO();
dtoScreen.SCREEN_CD = ScreenImport.ScreenCD;
dtoScreen.SCREEN_NAME = ScreenImport.ScreenName;
dtoScreen.ORIGINAL_TITLE = ScreenImport.ScreenName;
dtoScreen.IMAGE_CD.Value = "DEFAULT";
dtoScreen.SCREEN_TYPE = ScreenImport.ScreenType;
dtoScreen.SCREEN_ACTION.Value = 0;
dtoScreen.EXT_PROGRAM.Value = string.Empty;
dtoScreen.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreen.CRT_DATE.Value = DateTime.Now;
dtoScreen.CRT_MACHINE.Value = Environment.MachineName;
dtoScreen.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreen.UPD_DATE.Value = DateTime.Now;
dtoScreen.UPD_MACHINE.Value = Environment.MachineName;
screenDTOList.Add(dtoScreen);
if (langDTOList.Count > 0)
{
foreach (LangDTO langdto in langDTOList)
{
ScreenLangDTO dtoScreenLang = new ScreenLangDTO();
// add multilang for screen name
dtoScreenLang.SCREEN_CD = ScreenImport.ScreenCD;
dtoScreenLang.SCREEN_DESC = ScreenImport.ScreenName;
dtoScreenLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenLang.CRT_DATE.Value = DateTime.Now;
dtoScreenLang.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenLang.UPD_DATE.Value = DateTime.Now;
dtoScreenLang.UPD_MACHINE.Value = Environment.MachineName;
dtoScreenLang.LANG_CD = langdto.LANG_CD;
//bizScreenLang.AddNew(dtoScreenLang);
screenLangDTOList.Add(dtoScreenLang);
}
}
}
}
foreach (ScreenDetailUIDM ScreenDetail in UIDMScreenDetailList)
{
ScreenDetailDTO dtoScreenDetail = new ScreenDetailDTO();
dtoScreenDetail.SCREEN_CD = ScreenDetail.ScreenCD;
dtoScreenDetail.CONTROL_TYPE = ScreenDetail.ControlType;
dtoScreenDetail.ORIGINAL_TITLE = ScreenDetail.ControlCaption;
dtoScreenDetail.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.CRT_DATE.Value = DateTime.Now;
dtoScreenDetail.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetail.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetail.UPD_DATE.Value = DateTime.Now;
dtoScreenDetail.UPD_MACHINE.Value = Environment.MachineName;
dtoScreenDetail.CONTROL_CD = ScreenDetail.ControlCD;
screenDetailDTOList.Add(dtoScreenDetail);
if (langDTOList.Count > 0)
{
foreach (LangDTO langdto in langDTOList)
{
ScreenDetailLangDTO dtoScreenDetailLang = new ScreenDetailLangDTO();
// add spread column to screen detail ms
dtoScreenDetailLang.SCREEN_CD = ScreenDetail.ScreenCD;
dtoScreenDetailLang.CRT_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.CRT_DATE.Value = DateTime.Now;
dtoScreenDetailLang.CRT_MACHINE.Value = Environment.MachineName;
dtoScreenDetailLang.UPD_BY = CommonLib.Common.CurrentUserInfomation.UserCD;
dtoScreenDetailLang.UPD_DATE.Value = DateTime.Now;
dtoScreenDetailLang.UPD_MACHINE.Value = Environment.MachineName;
// add multilang for spread column
dtoScreenDetailLang.CONTROL_CD = ScreenDetail.ControlCD; //.Value = fpsspread.Name + ".Column[" + i.ToString() + "]";
dtoScreenDetailLang.CONTROL_CAPTION = ScreenDetail.ControlCaption; //.Value = fpsspread.Sheets[0].Columns[i].Label;
dtoScreenDetailLang.LANG_CD = langdto.LANG_CD;
screenDetailLangDTOList.Add(dtoScreenDetailLang);
}
}
}
#endregion
ImportScreenBIZ bizImportScreen = new ImportScreenBIZ();
bizImportScreen.ImportData(screenDTOList, screenLangDTOList, screenDetailDTOList, screenDetailLangDTOList);
}
//public int DeletebyScreenCD(NZString nZString)
//{
// ScreenLangDAO dao = new ScreenLangDAO(CommonLib.Common.CurrentDatabase);
// return dao.DeletebyScreenCD(null, nZString);
//}
public int UpdateScreenDisplayText(ScreenLangDTO dto)
{
IScreenLangDAO dao = DAOFactory.CreateScreenLangDAO(CommonLib.Common.CurrentDatabase);
return(dao.UpdateWithoutPK(null, dto));
}
public int AddNew(ScreenLangDTO dtoScreenLang)
{
IScreenLangDAO dao = DAOFactory.CreateScreenLangDAO(CommonLib.Common.CurrentDatabase);
return(dao.AddNew(null, dtoScreenLang));
}
