public int SaveData(string strConSQL, string strSP, IAHeaders header, DataTable dtModel, DataTable dtPart, DataTable dtDepartment, DataTable dtDepartmentDetail)
{
int result = (int)SaveStatus.Initial;
SqlConnection con = new SqlConnection(ConString);
SqlCommand cmd = new SqlCommand(strSP, con);
AddInParameter(cmd, "@IAid", header.IAId);
AddInParameter(cmd, "@IAType", header.IAType);
AddInParameter(cmd, "@InternalEpcNumber", header.InternalEpcNumber);
AddInParameter(cmd, "@InfoNumber", header.InfoNumber);
AddInParameter(cmd, "@InfoFrom", header.InfoFrom);
AddInParameter(cmd, "@Description", header.Description);
AddInParameter(cmd, "@ValidPeriodFrom", header.ValidPeriodFrom);
AddInParameter(cmd, "@ValidPeriodTo", header.ValidPeriodTo);
AddInParameter(cmd, "@ImplementationDate", header.ImplementationDate == DateTime.MinValue ? null : header.ImplementationDate);
AddInParameter(cmd, "@DynamicCheck", header.DynamicCheck);
AddInParameter(cmd, "@AuthorUserId", header.AuthorUserId);
AddInParameter(cmd, "@StatusID", header.StatusID);
AddInParameter(cmd, "@TvpIAModel", dtModel);
AddInParameter(cmd, "@TvpIAPart", dtPart);
AddInParameter(cmd, "@TvpIADepartment", dtDepartment);
AddInParameter(cmd, "@TvpIADepartmentDetail", dtDepartmentDetail);
try
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
cmd.ExecuteNonQuery();
result = (int)SaveStatus.Success;
}
catch (Exception e)
{
result = (int)SaveStatus.Error;
AppLogger.LogError(e);
}
finally
{
con.Close();
con.Dispose();
}
return(result);
}
public List <IAHeaders> GetDataIrregAlt(int id, string strSP)
{
List <IAHeaders> getData = new List <IAHeaders>();
SqlConnection con = new SqlConnection(ConString);
SqlCommand cmd = new SqlCommand(strSP, con);
SqlDataReader reader = null;
AddInParameter(cmd, "@id", Convert.ToString(id));
try
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
reader = cmd.ExecuteReader();
while (reader.Read())
{
IAHeaders irregAlt = new IAHeaders();
if (reader["IsDynamicCheck"] != DBNull.Value)
{
irregAlt.DynamicCheck = reader["IsDynamicCheck"] == null ? false : true;
}
if (reader["IAType"] != DBNull.Value)
{
irregAlt.IAType = reader["IAType"].ToString();
}
if (reader["InternalEpcNumber"] != DBNull.Value)
{
irregAlt.InternalEpcNumber = reader["InternalEpcNumber"].ToString();
}
if (reader["InfoNumber"] != DBNull.Value)
{
irregAlt.InfoNumber = reader["InfoNumber"].ToString();
}
if (reader["Description"] != DBNull.Value)
{
irregAlt.Description = reader["Description"].ToString();
}
if (reader["ValidPeriodFrom"] != DBNull.Value)
{
irregAlt.ValidPeriodFrom = Convert.ToDateTime(reader["ValidPeriodFrom"]);
}
if (reader["ValidPeriodTo"] != DBNull.Value)
{
irregAlt.ValidPeriodTo = Convert.ToDateTime(reader["ValidPeriodTo"]);
}
if (reader["ImplementationDate"] != DBNull.Value)
{
irregAlt.ImplementationDate = Convert.ToDateTime(reader["ImplementationDate"]);
}
getData.Add(irregAlt);
}
}
catch (Exception e)
{
AppLogger.LogError(e);
}
finally
{
con.Close();
con.Dispose();
}
return(getData);
}
