public List <TrimsSub> GetTrimsSubData(TrimsModel objTrimsModel)
{
List <TrimsSub> objTrimsSubMainList = new List <TrimsSub>();
string sql = "";
sql = "SELECT " +
"ACCESSORIES_ID, " +
"ACCESSORIES_NAME, " +
"TRIMS_CODE, " +
"TRAN_ID, " +
"PER_GARMENTS_QUANTITY, " +
"TOTAL_QUANTITY, " +
"STYLE_NO, " +
"SEASON_ID, " +
"SEASON_YEAR, " +
"BRANCH_OFFICE_ID " +
" FROM VEW_TRIMS_DETAIL_SUB where HEAD_OFFICE_ID = '" + objTrimsModel.HeadOfficeId + "' AND BRANCH_OFFICE_ID = '" + objTrimsModel.BranchOfficeId + "' AND STYLE_NO = '" + objTrimsModel.StyleNo + "' AND SEASON_ID = '" + objTrimsModel.SeasonId + "' AND SEASON_YEAR = '" + objTrimsModel.SeasonYear + "' ";
OracleCommand objCommand = new OracleCommand(sql);
OracleDataReader objDataReader;
using (OracleConnection strConn = GetConnection())
{
objCommand.Connection = strConn;
strConn.Open();
objDataReader = objCommand.ExecuteReader();
try
{
while (objDataReader.Read())
{
TrimsSub trimsSub = new TrimsSub();
trimsSub.Accessories = objDataReader.GetValue(0).ToString();
trimsSub.TrimsCode = objDataReader.GetValue(2).ToString();
trimsSub.TranId = objDataReader.GetValue(3).ToString();
trimsSub.PerGarmentsQuantity = objDataReader.GetValue(4).ToString();
trimsSub.TotalQuantity = objDataReader.GetValue(5).ToString();
trimsSub.StyleNo = objDataReader.GetValue(6).ToString();
trimsSub.SeasoneId = objDataReader.GetValue(7).ToString();
trimsSub.SeasoneYear = objDataReader.GetValue(8).ToString();
objTrimsSubMainList.Add(trimsSub);
}
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
strConn.Close();
}
}
return(objTrimsSubMainList);
}
public string TrimsSubDelete(TrimsSub objTrimsSub)
{
string strMsg = "";
OracleCommand objOracleCommand = new OracleCommand("pro_delete_Trims_sub");
objOracleCommand.CommandType = CommandType.StoredProcedure;
objOracleCommand.Parameters.Add("p_tran_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.TranId) ? objTrimsSub.TranId : null;
objOracleCommand.Parameters.Add("p_style_no", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.StyleNo) ? objTrimsSub.StyleNo : null;
objOracleCommand.Parameters.Add("p_season_year", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.SeasoneYear) ? objTrimsSub.SeasoneYear : null;
objOracleCommand.Parameters.Add("p_season_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.SeasoneId) ? objTrimsSub.SeasoneId : null;
objOracleCommand.Parameters.Add("p_head_office_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.HeadOfficeId) ? objTrimsSub.HeadOfficeId : null;
objOracleCommand.Parameters.Add("p_branch_office_id", OracleDbType.Varchar2, ParameterDirection.InputOutput).Value = !string.IsNullOrWhiteSpace(objTrimsSub.BranchOfficeId) ? objTrimsSub.BranchOfficeId : null;
objOracleCommand.Parameters.Add("P_MESSAGE", OracleDbType.Varchar2, 500).Direction = ParameterDirection.Output;
using (OracleConnection strConn = GetConnection())
{
try
{
objOracleCommand.Connection = strConn;
strConn.Open();
trans = strConn.BeginTransaction();
objOracleCommand.ExecuteNonQuery();
trans.Commit();
strConn.Close();
strMsg = objOracleCommand.Parameters["P_MESSAGE"].Value.ToString();
}
catch (Exception ex)
{
throw new Exception("Error : " + ex.Message);
}
finally
{
strConn.Close();
}
}
return(strMsg);
}
