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