public static void SaveSheduleCourseBatch(System.Data.DataTable dt, clsCourseSheduleAssign sheduleObj) { SqlConnection connection = new SqlConnection(DataManager.OraConnString()); SqlTransaction transection; try { connection.Open(); transection = connection.BeginTransaction(); SqlCommand command = new SqlCommand(); command.Connection = connection; command.Transaction = transection; SqlCommand command1 = new SqlCommand(); command1.Connection = connection; command1.Transaction = transection; command.CommandText = "Select ID,CourseID,FacultyID,BatchNo,Status,Flag,SheduleStartDate,SheduleEndDate from TBL_SHEDULE_ENTRY_MST where BatchNo='" + sheduleObj.BatchNo + "' and CourseID='" + sheduleObj.CourseID + "'"; int Count = Convert.ToInt32(command.ExecuteScalar()); if (Count > 0) { command.CommandText = @"delete from [TBL_SHEDULE_ENTRY_MST] where BatchNo='" + sheduleObj.BatchNo + "' and CourseID='" + sheduleObj.CourseID + "'"; command.ExecuteNonQuery(); command1.CommandText = @"INSERT INTO [TBL_SHEDULE_ENTRY_MST] ([TracID],[CourseID],[FacultyID],[BatchNo],[Status],[Flag],[SheduleStartDate],[SheduleEndDate],[EntryBy],[EntryDate]) VALUES ('" + sheduleObj.TracID + "','" + sheduleObj.CourseID + "','" + sheduleObj.FacultyID + "','" + sheduleObj.BatchNo + "','" + sheduleObj.Status + "',1,convert(date,'" + sheduleObj.StartDate + "',103),convert(date,'" + sheduleObj.EndDate + "',103),'" + sheduleObj.LoginBy + "',GETDATE() )"; command1.ExecuteNonQuery(); command.CommandText = @"SELECT TOP(1)[ID] FROM [TBL_SHEDULE_ENTRY_MST] ORDER BY ID DESC"; int ID = Convert.ToInt32(command.ExecuteScalar()); foreach (DataRow drsh in dt.Rows) { if (drsh["DaysID"].ToString() != "") { string StartDateTime = //DateTime.Now.ToString("MM/dd/yyyy") + " " + drsh["StartTime"].ToString() + " " + drsh["StartAmPm"].ToString(); string EndDateTime = //DateTime.Now.ToString("MM/dd/yyyy") + " " + drsh["EndtTime"].ToString() + " " + drsh["EndAmPm"].ToString(); command.CommandText = @"INSERT INTO [TBL_SHEDULE_ENTRY_DTL] ([MSTID],[Days],[StartTime],[EndTime],[RoomNo],[Flag]) VALUES ('" + ID + "','" + drsh["DaysID"].ToString() + "',convert(datetime,'" + drsh["StartTime"].ToString() + "',103),convert(datetime,'" + drsh["EndtTime"].ToString() + "',103),'" + drsh["RoomNo"].ToString() + "','1')"; command.ExecuteNonQuery(); } } } else { command1.CommandText = @"INSERT INTO [TBL_SHEDULE_ENTRY_MST] ([TracID],[CourseID],[FacultyID],[BatchNo],[Status],[Flag],[SheduleStartDate],[SheduleEndDate],[EntryBy],[EntryDate]) VALUES ('" + sheduleObj.TracID + "','" + sheduleObj.CourseID + "','" + sheduleObj.FacultyID + "','" + sheduleObj.BatchNo + "','" + sheduleObj.Status + "',1,convert(datetime,'" + sheduleObj.StartDate + "',103),convert(datetime,'" + sheduleObj.EndDate + "',103),'" + sheduleObj.LoginBy + "',GETDATE() )"; command1.ExecuteNonQuery(); command.CommandText = @"SELECT TOP(1)[ID] FROM [TBL_SHEDULE_ENTRY_MST] ORDER BY ID DESC"; int ID = Convert.ToInt32(command.ExecuteScalar()); foreach (DataRow drsh in dt.Rows) { if (drsh["DaysID"].ToString() != "") { string StartDateTime = //DateTime.Now.ToString("MM/dd/yyyy") //+ " " + drsh["StartTime"].ToString() + " " + drsh["StartAmPm"].ToString(); string EndDateTime = //DateTime.Now.ToString("MM/dd/yyyy") //+ " " + drsh["EndtTime"].ToString() + " " + drsh["EndAmPm"].ToString(); command.CommandText = @"INSERT INTO [TBL_SHEDULE_ENTRY_DTL] ([MSTID],[Days],[StartTime],[EndtTime],[RoomNo],[Flag]) VALUES ('" + ID + "','" + drsh["DaysID"].ToString() + "',convert(datetime,'" + StartDateTime + "',103),convert(datetime,'" + EndDateTime + "',103),'" + drsh["RoomNo"].ToString() + "','1')"; command.ExecuteNonQuery(); } } } transection.Commit(); connection.Close(); } catch (Exception ex) { throw new Exception(ex.Message); } }
protected void btnSave_Click(object sender, EventArgs e) { try { if (!string.IsNullOrEmpty(hfID.Value)) { } else { if (ddlCourseName.SelectedValue == "") { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Please Select course name...!!');", true); return; } if (string.IsNullOrEmpty(lblFacultyID.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Input faculty Name...!!');", true); return; } if (string.IsNullOrEmpty(txtBatchNo.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Input batch no...!!');", true); return; } if (string.IsNullOrEmpty(txtStartDate.Text)) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Please Select start date...!!');", true); return; } else { clsCourseSheduleAssign sheduleObj = new clsCourseSheduleAssign(); sheduleObj.TracID = ddlCourseTrac.SelectedValue.Replace("'", ""); sheduleObj.CourseID = ddlCourseName.SelectedValue.Replace("'", ""); sheduleObj.FacultyID = lblFacultyID.Text.Replace("'", ""); sheduleObj.BatchNo = txtBatchNo.Text.Replace("'", ""); sheduleObj.StartDate = DataManager.DateEncode(txtStartDate.Text.Replace("'", "")).ToString(); sheduleObj.EndDate = DataManager.DateEncode(txtEndDate.Text.Replace("'", "")).ToString(); sheduleObj.Status = ddlStatus.SelectedValue.Replace("'", ""); sheduleObj.Year = txtYear.Text.Replace("'", ""); sheduleObj.LoginBy = Session["USER_ID"].ToString(); DataTable dt = (DataTable)ViewState["itemdtl"]; DataTable NewDt = new DataTable(); NewDt.Columns.Add("ID", typeof(string)); NewDt.Columns.Add("DaysID", typeof(string)); NewDt.Columns.Add("StartTime", typeof(string)); NewDt.Columns.Add("StartAmPm", typeof(string)); NewDt.Columns.Add("EndtTime", typeof(string)); NewDt.Columns.Add("EndAmPm", typeof(string)); NewDt.Columns.Add("RoomNo", typeof(string)); if (dt != null) { if (dt.Rows.Count > 0) { DataTable dtResult = (DataTable)Session["ShList"]; if (dtResult != null) { //dtResult.AsEnumerable() // .Where(r => r.Field<string>("ID") == lblID.Text.Trim() || r.Field<string>("ID") == "") // .ToList() // .ForEach(row => row.Delete()); foreach (DataRow dr1 in dtResult.Rows) { if (dr1["ID"].ToString().Trim() == lblID.Text.Trim() || dr1["ID"].ToString().Trim() == "") { } else { NewDt.Rows.Add(dr1["ID"].ToString(), dr1["DaysID"].ToString(), dr1["StartTime"].ToString(), dr1["StartAmPm"].ToString(), dr1["EndtTime"].ToString(), dr1["EndAmPm"].ToString(), dr1["RoomNo"].ToString()); } } foreach (DataRow dr in dt.Rows) { if (dr["ID"].ToString() != "") { NewDt.Rows.Add(dr["ID"].ToString(), dr["DaysID"].ToString(), dr["StartTime"].ToString(), dr["StartAmPm"].ToString(), dr["EndtTime"].ToString(), dr["EndAmPm"].ToString(), dr["RoomNo"].ToString()); } } Session["ShList"] = NewDt; } else { Session["ShList"] = dt; } } CourseSheduleAssaignManager.SaveSheduleCourseBatch(dt, sheduleObj); ScriptManager.RegisterClientScriptBlock(this, this.GetType(), "ale", "alert('Record(s) is/are created suceessfullly...!!');", true); Refresh(); } } } } catch (FormatException fex) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('" + fex.Message + "');", true); } catch (Exception ex) { if (ex.Message.Contains("Database")) { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('Database Maintain Error. Contact to the Software Provider..!!');", true); } else { ClientScript.RegisterStartupScript(this.GetType(), "Warning", "alert('There is some problem to do the task. Try again properly.!!');", true); } } }