public int SaveRevisionHeader(RevisionHeader rHeader)
{
SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString);
con.Open();
SqlCommand cmd = new SqlCommand("SaveRevisionHeader", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RevisionNo", rHeader.RevisionNo.ToString());
cmd.Parameters.AddWithValue("@RevisionDate", rHeader.RevisionDate.ToString());
cmd.Parameters.AddWithValue("@CreatedBy", 1);
if (rHeader.Id > 0)
{
cmd.Parameters.AddWithValue("@RevisionHeaderId", rHeader.Id);
}
else
{
cmd.Parameters.AddWithValue("@RevisionHeaderId ", DBNull.Value);
}
int recordsAffected = cmd.ExecuteNonQuery();
con.Close();
return(recordsAffected);
}
public List <RevisionHeader> GetRevisionHeaderForDrp()
{
List <RevisionHeader> rHeaderList = new List <RevisionHeader>();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetRevisionHeaderForDropDown", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
RevisionHeader rHeader = new RevisionHeader();
rHeader.Id = Convert.ToInt32(dr["Id"]);
//rHeader.RevisionNo = Convert.ToString(dr["RevisionNo"]);
//rHeader.RevisionDate = Convert.ToString(dr["RevisionDate"]);
rHeader.RevisionName = Convert.ToString(dr["RevisionNo"]) + " " + Convert.ToString(dr["RevisionDate"]);
rHeaderList.Add(rHeader);
}
}
}
return(rHeaderList);
}
public JsonResult SaveRevisionHeader(RevisionHeader rHeader)
{
RevisionHistoryBL rhBl = new RevisionHistoryBL();
int x = rhBl.SaveRevisionHeader(rHeader);
return(Json(x, JsonRequestBehavior.AllowGet));
}
public RevisionHeaderHistoryViewModel GetAllRevisionDetails()
{
RevisionHeaderHistoryViewModel rhhVM = new RevisionHeaderHistoryViewModel();
using (SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["TCCCMSDBConnectionString"].ConnectionString))
{
using (SqlCommand cmd = new SqlCommand("GetRevisionDetails", con))
{
cmd.CommandType = CommandType.StoredProcedure;
con.Open();
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
List <RevisionHeader> rHeaderList = new List <RevisionHeader>();
foreach (DataRow dr in ds.Tables[0].Rows)
{
RevisionHeader rHeader = new RevisionHeader();
rHeader.Id = Convert.ToInt32(dr["Id"]);
rHeader.RevisionNo = Convert.ToString(dr["RevisionNo"]);
rHeader.RevisionDate = Convert.ToString(dr["RevisionDate"]);
var histRows = ds.Tables[1].Rows
.Cast <DataRow>()
.Where(x => x.Field <int>(5) == rHeader.Id).ToList();
List <RevisionHistory> rhList = new List <RevisionHistory>();
foreach (DataRow drh in histRows)
{
RevisionHistory rh = new RevisionHistory();
rh.ID = Convert.ToInt32(drh["RevisionHistoryId"]);
rh.Chapter = Convert.ToString(drh["Chapter"]);
rh.Section = Convert.ToString(drh["Section"]);
rh.ChangeComment = Convert.ToString(drh["ChangeComment"]);
rh.ModificationDate = Convert.ToString(drh["ModificationDate"]);
rh.HeaderId = Convert.ToInt32(drh["HeaderId"]);
rhList.Add(rh);
}
rHeader.RevisionHistoryList = rhList;
rHeaderList.Add(rHeader);
}
rhhVM.RevisionHeaderList = rHeaderList;
}
}
return(rhhVM);
}
public int SaveRevisionHeader(RevisionHeader rHeader)
{
RevisionHistoryDAL rhDal = new RevisionHistoryDAL();
return(rhDal.SaveRevisionHeader(rHeader));
}
