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); }