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