public PlanWeeks GetByID(int Year, string Month, int WeekID) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Year", Year), new SqlParameter("@Month", Month), new SqlParameter("@WeekID", WeekID) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PlanWeeks", paramList); PlanWeeks obj = new PlanWeeks(); if (dt.Rows.Count > 0) { obj.State = Convert.ToInt32(dt.Rows[0]["State"]); obj.FromDate = Convert.ToDateTime(dt.Rows[0]["FromDate"]); obj.ToDate = Convert.ToDateTime(dt.Rows[0]["ToDate"]); obj.WeekID = Convert.ToInt32(dt.Rows[0]["WeekID"]); obj.Month = Convert.ToString(dt.Rows[0]["Month"]); obj.Year = Convert.ToInt32(dt.Rows[0]["Year"]); } return(obj); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
//---------------------ADD REGION------------------------------ public int Add(PlanWeeks objPlanWeeks) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Year", objPlanWeeks.Year), new SqlParameter("@Month", objPlanWeeks.Month), new SqlParameter("@WeekID", objPlanWeeks.WeekID), new SqlParameter("@FromDate", objPlanWeeks.FromDate), new SqlParameter("@ToDate", objPlanWeeks.ToDate), new SqlParameter("@State", objPlanWeeks.State) }; return(Execute.RunSP_RowsEffected(Connection, "SPADD_PlanWeeks", paramList)); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }
private void CreatePlanningWeeks() { PlanWeeks objPlanWeeks = new PlanWeeks(); objPlanWeeks.Year = Convert.ToInt32(cmbYear.Text); objPlanWeeks.Month = cmbMonth.Text; objPlanWeeks.WeekID = Convert.ToInt32(cmbWeekID.Text); objPlanWeeks.FromDate = dtpFirstWeekStart.Value; objPlanWeeks.ToDate = dtpFirstWeekStop.Value; objPlanWeeks.State = 0; bool y = Validate(); if (y == true) { objPlanWeek_DL.Add(objPlanWeeks); } else { MessageBox.Show(this, "Incorrect Selections", "Incorrect Attempt", MessageBoxButtons.OK); } }
public PlanWeeksCollec GetByMonth(int Year, string Month) { try { SqlParameter[] paramList = new SqlParameter[] { new SqlParameter("@Year", Year), new SqlParameter("@Month", Month) }; DataTable dt = Execute.RunSP_DataTable(Connection, "SPGET_PlanWeeks_ByMonth", paramList); PlanWeeksCollec objCollec = new PlanWeeksCollec(); if (dt.Rows.Count > 0) { PlanWeeks obj = new PlanWeeks(); for (int i = 0; i < dt.Rows.Count; i++) { obj.State = Convert.ToInt32(dt.Rows[i]["State"]); obj.FromDate = Convert.ToDateTime(dt.Rows[i]["FromDate"]); obj.ToDate = Convert.ToDateTime(dt.Rows[i]["ToDate"]); obj.WeekID = Convert.ToInt32(dt.Rows[i]["WeekID"]); obj.Month = Convert.ToString(dt.Rows[i]["Month"]); obj.Year = Convert.ToInt32(dt.Rows[i]["Year"]); } objCollec.Add(obj); } return(objCollec); } catch (Exception ex) { throw new Exception(ex.Message, ex); } }