/// <summary>
/// checks duplicate Line Building
/// </summary>
/// <param name="usrBuildingLineVo"></param>
/// <returns></returns>
private UserLineBuildingVo DuplicateCheck(UserLineBuildingVo usrBuildingLineVo)
{
UserLineBuildingVo outVo = new UserLineBuildingVo();
try
{
outVo = (UserLineBuildingVo)base.InvokeCbm(new CheckUserLineBuildingMasterMntCbm(), usrBuildingLineVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserLineBuildingVo inVo = (UserLineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_user_line_building");
sqlQuery.Append(" ( ");
sqlQuery.Append(" line_building_id, ");
sqlQuery.Append(" user_cd, ");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :linebuildingid ,");
sqlQuery.Append(" :usercd ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("usercd", inVo.UserCode);
sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId);
sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserLineBuildingVo inVo = (UserLineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_user_line_building");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.LineBuildingId > 0)
{
sqlQuery.Append(" AND line_building_id = :linebuildingid");
}
if (inVo.UserCode != null)
{
sqlQuery.Append(" AND user_cd = :usercd");
}
if (inVo.LineBuildingidList.Count > 0)
{
sqlQuery.Append(" AND line_building_id = ANY(:idlist) ");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId);
sqlParameter.AddParameterString("usercd", inVo.UserCode);
sqlParameter.AddParameter("idlist", inVo.LineBuildingidList);
UpdateResultVo outVo = new UpdateResultVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserLineBuildingVo inVo = (UserLineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as UserLineBuildingCount from m_user_line_building");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.LineBuildingId >= 0)
{
sqlQuery.Append(" and line_building_id = :linebuildingid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.LineBuildingId >= 0)
{
sqlParameter.AddParameterInteger("linebuildingid", inVo.LineBuildingId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
UserLineBuildingVo outVo = new UserLineBuildingVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["UserLineBuildingCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
UserLineBuildingVo inVo = (UserLineBuildingVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select");
sqlQuery.Append(" lb.line_building_id,");
sqlQuery.Append(" lb.building_id,");
sqlQuery.Append(" lb.line_id,");
sqlQuery.Append(" b.building_cd,");
sqlQuery.Append(" b.building_name,");
sqlQuery.Append(" l.line_cd,");
sqlQuery.Append(" l.line_name,");
sqlQuery.Append(" ulb.line_building_id AS UserLineBuildingId,");
sqlQuery.Append(" ulb.user_cd");
sqlQuery.Append(" from m_line_building lb");
sqlQuery.Append(" inner join m_line l on lb.line_id = l.line_id");
sqlQuery.Append(" inner join m_building b on lb.building_id = b.building_id");
sqlQuery.Append(" left join m_user_line_building ulb on lb.line_building_id = ulb.line_building_id");
sqlQuery.Append(" where lb.factory_cd = :faccd ");
if (inVo.BuildingId > 0)
{
sqlQuery.Append(" and lb.building_id = :buildingid");
}
if (inVo.LineId > 0)
{
sqlQuery.Append(" and lb.line_id = :lid");
}
if (inVo.LineCode != null)
{
sqlQuery.Append(" and l.line_cd = :lcd");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
sqlParameter.AddParameterInteger("buildingid", inVo.BuildingId);
sqlParameter.AddParameterInteger("lid", inVo.LineId);
sqlParameter.AddParameterString("lcd", inVo.LineCode);
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ValueObjectList <UserLineBuildingVo> outVo = null;
while (dataReader.Read())
{
UserLineBuildingVo currOutVo = new UserLineBuildingVo
{
LineBuildingId = Convert.ToInt32(dataReader["line_building_id"]),
BuildingId = Convert.ToInt32(dataReader["building_id"]),
LineId = Convert.ToInt32(dataReader["line_id"]),
LineCode = dataReader["line_cd"].ToString(),
LineName = dataReader["line_name"].ToString(),
BuildingCode = dataReader["building_cd"].ToString(),
BuildingName = dataReader["building_name"].ToString(),
UserLineBuildingId = ConvertDBNull <int>(dataReader, "UserLineBuildingId"),
UserCode = ConvertDBNull <string>(dataReader, "user_cd")
};
if (outVo == null)
{
outVo = new ValueObjectList <UserLineBuildingVo>();
}
outVo.add(currOutVo);
}
dataReader.Close();
return(outVo);
}
/// <summary>
/// inserts/updates process on ok click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Update_btn_Click(object sender, EventArgs e)
{
if (!CheckMandatory() || LineBuildingMasterVo == null || LineBuildingMasterVo.GetList() == null)
{
return;
}
UserLineBuildingVo inVo = new UserLineBuildingVo();
inVo.UserCode = User_cmb.SelectedValue.ToString();
inVo.LineBuildingidList = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == Convert.ToInt32(Building_lst.SelectedValue)).Select(s => s.LineBuildingId).ToList();
try
{
UpdateResultVo outDeleteVo = (UpdateResultVo)base.InvokeCbm(new DeleteUserLineBuildingMasterMntCbm(), inVo, false);
IntDelSuccess = outDeleteVo.AffectedCount;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
inVo.BuildingId = Convert.ToInt32(Building_lst.SelectedValue);
UpdateResultVo outVo = new UpdateResultVo();
foreach (UserLineBuildingVo item in Line_chlst.CheckedItems)
{
inVo.LineId = item.LineId;
UserLineBuildingVo currentVo = LineBuildingMasterVo.GetList().Where(t => t.BuildingId == inVo.BuildingId && t.LineId == inVo.LineId).FirstOrDefault();
if (currentVo == null || currentVo.LineBuildingId == 0)
{
messageData = new MessageData("mmce00010", Properties.Resources.mmce00010, "LineBuildingId");
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
inVo.LineBuildingId = currentVo.LineBuildingId;
try
{
outVo = (UpdateResultVo)base.InvokeCbm(new AddUserLineBuildingMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
IntSuccess = outVo.AffectedCount;
if ((IntSuccess > 0) || (IntDelSuccess > 0))
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
/// <summary>
/// Get Line Data.
/// </summary>
private void LoadLineListBox()
{
this.Cursor = Cursors.WaitCursor;
Line_chlst.DataSource = null;
UserLineBuildingVo inVo = new UserLineBuildingVo();
inVo.BuildingId = Convert.ToInt32(Building_lst.SelectedValue.ToString());
try
{
LineBuildingMasterVo = (ValueObjectList <UserLineBuildingVo>)base.InvokeCbm(new GetUserLineBuildingMasterMntCbm(), inVo, false);
}
catch (Framework.ApplicationException ex)
{
logger.Info(ex.GetMessageData());
popUpMessage.ApplicationError(ex.GetMessageData(), Text);
}
if (LineBuildingMasterVo == null || LineBuildingMasterVo.GetList() == null || LineBuildingMasterVo.GetList().Count == 0)
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, Line_lbl.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
Update_btn.Enabled = false;
this.Cursor = Cursors.Default;
return;
}
List <UserLineBuildingVo> FilteruserlinebuildingVo = LineBuildingMasterVo.GetList().GroupBy(t => new { t.LineId })
.Select(g => new UserLineBuildingVo
{
LineId = g.First().LineId,
LineBuildingId = g.First().LineBuildingId,
BuildingId = g.First().BuildingId,
BuildingCode = g.First().BuildingCode,
BuildingName = g.First().BuildingName,
LineCode = g.First().LineCode,
LineName = g.First().LineCode + " " + g.First().LineName,
}).ToList();
if (FilteruserlinebuildingVo.Count > 0)
{
Line_chlst.DataSource = FilteruserlinebuildingVo.OrderBy(o => o.LineCode).ToList();
Line_chlst.DisplayMember = "LineName";
Line_chlst.ValueMember = "LineId";
Update_btn.Enabled = true;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, Line_lbl.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
Update_btn.Enabled = false;
}
UserLineBuildingVo chekLineIdVo;
Line_chlst.ClearSelected();
if (LineBuildingMasterVo != null || LineBuildingMasterVo.GetList() != null || LineBuildingMasterVo.GetList().Count > 0)
{
for (int i = 0; i < Line_chlst.Items.Count; i++)
{
UserLineBuildingVo currline = (UserLineBuildingVo)Line_chlst.Items[i];
chekLineIdVo = LineBuildingMasterVo.GetList().Where(t => t.LineId == currline.LineId && t.UserCode == User_cmb.SelectedValue.ToString()).FirstOrDefault();
if (chekLineIdVo == null)
{
continue;
}
if (chekLineIdVo.UserLineBuildingId > 0)
{
Line_chlst.SetItemChecked(i, true);
}
}
}
this.Cursor = Cursors.Default;
}
