public static TMSLeaveDetails Get(System.Int64 ldLeaveDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSLeaveDetails instance;
instance = new TMSLeaveDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSLeaveDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ldLeaveDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0)
{
throw new ApplicationException("Could not get TMSLeaveDetails ID:" + ldLeaveDetailsId.ToString() + " from Database.");
}
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom(ds.Tables[0].Rows[0]);
return(instance);
}
public static TMSLeaveDetails[] Search(System.Int64?ldLeaveDetailsId, System.Int64?ldFacultyLoginId, System.String ldFacultyType, System.Int32?ldCasualLeave, System.Int32?ldEarnedLeave, System.Int32?ldPaidLeave, System.Int32?ldSickLeave, System.Int32?ldOtherLeave, System.Int32?ldMartialLeave, System.Int32?ldMartinityLeave, System.String ldExtra1, System.String ldExtra2, System.DateTime?ldDate, System.String ldYear, System.Int64?ldAddedById, System.String ldAddedByRemarks, System.String ldOtherRemark, System.Int32?ldStatus)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSLeaveDetails_SEARCH";
dbCommand = db.GetStoredProcCommand(sqlCommand, ldLeaveDetailsId, ldFacultyLoginId, ldFacultyType, ldCasualLeave, ldEarnedLeave, ldPaidLeave, ldSickLeave, ldOtherLeave, ldMartialLeave, ldMartinityLeave, ldExtra1, ldExtra2, ldDate, ldYear, ldAddedById, ldAddedByRemarks, ldOtherRemark, ldStatus);
ds = db.ExecuteDataSet(dbCommand);
ds.Tables[0].TableName = TABLE_NAME;
return(TMSLeaveDetails.MapFrom(ds));
}
protected void GetLeaveDetails()
{
try
{
DataTable dt = TMSLeaveDetails.GetLeaveDetailsBytype(Convert.ToInt64(Session["UserId"]), "Staff").Tables[0];
if (dt.Rows.Count > 0)
{
if (dt.Rows[0]["LD_CasualLeave"].ToString() != "")
{
lblcasualLeave.Text = dt.Rows[0]["LD_CasualLeave"].ToString();
}
if (dt.Rows[0]["LD_EarnedLeave"].ToString() != "")
{
lblEarnedLeave.Text = dt.Rows[0]["LD_EarnedLeave"].ToString();
}
if (dt.Rows[0]["LD_PaidLeave"].ToString() != "")
{
lblPaidLeave.Text = dt.Rows[0]["LD_PaidLeave"].ToString();
}
if (dt.Rows[0]["LD_SickLeave"].ToString() != "")
{
lblseakleave.Text = dt.Rows[0]["LD_SickLeave"].ToString();
}
if (dt.Rows[0]["LD_MartialLeave"].ToString() != "")
{
lblMaritalLeave.Text = dt.Rows[0]["LD_MartialLeave"].ToString();
}
if (dt.Rows[0]["LD_MartinityLeave"].ToString() != "")
{
lblMaternityLeave.Text = dt.Rows[0]["LD_MartinityLeave"].ToString();
}
}
}
catch { }
}
public static TMSLeaveDetails[] MapFrom(DataSet ds)
{
List <TMSLeaveDetails> objects;
// Initialise Collection.
objects = new List <TMSLeaveDetails>();
// Validation.
if (ds == null)
{
throw new ApplicationException("Cannot map to dataset null.");
}
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
{
return(objects.ToArray());
}
if (ds.Tables[TABLE_NAME] == null)
{
throw new ApplicationException("Cannot find table [dbo].[TMS_LeaveDetails] in DataSet.");
}
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
{
throw new ApplicationException("Table [dbo].[TMS_LeaveDetails] is empty.");
}
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSLeaveDetails instance = new TMSLeaveDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return(objects.ToArray());
}
public static DataSet GetSearch(TMSLeaveDetails searchObject)
{
return GetSearch(searchObject.LDLeaveDetailsId, searchObject.LDFacultyLoginId, searchObject.LDFacultyType, searchObject.LDCasualLeave, searchObject.LDEarnedLeave, searchObject.LDPaidLeave, searchObject.LDSickLeave, searchObject.LDOtherLeave, searchObject.LDMartialLeave, searchObject.LDMartinityLeave, searchObject.LDExtra1, searchObject.LDExtra2, searchObject.LDDate, searchObject.LDYear, searchObject.LDAddedById, searchObject.LDAddedByRemarks, searchObject.LDOtherRemark, searchObject.LDStatus);
}
public static TMSLeaveDetails[] Search(TMSLeaveDetails searchObject)
{
return(Search(searchObject.LDLeaveDetailsId, searchObject.LDFacultyLoginId, searchObject.LDFacultyType, searchObject.LDCasualLeave, searchObject.LDEarnedLeave, searchObject.LDPaidLeave, searchObject.LDSickLeave, searchObject.LDOtherLeave, searchObject.LDMartialLeave, searchObject.LDMartinityLeave, searchObject.LDExtra1, searchObject.LDExtra2, searchObject.LDDate, searchObject.LDYear, searchObject.LDAddedById, searchObject.LDAddedByRemarks, searchObject.LDOtherRemark, searchObject.LDStatus));
}
public static void Update(TMSLeaveDetails tMSLeaveDetails, DbTransaction transaction)
{
tMSLeaveDetails.Update(transaction);
}
public static void Update(TMSLeaveDetails tMSLeaveDetails)
{
tMSLeaveDetails.Update();
}
protected void ChecKAccount()
{
DataTable dt = TMSLeaveDetails.GetSearch(null, Convert.ToInt64(Session["AccountID"]), Session["type"].ToString(), null, null, null, null, null, null, null, null, null, null, null, null, null, null, 1).Tables[0];
if (dt.Rows.Count > 0)
{
Int64 ID = Convert.ToInt64(dt.Rows[0]["LD_LeaveDetailsId"]);
hiddLeaveID.Value = dt.Rows[0]["LD_LeaveDetailsId"].ToString();
btnsave.Text = "Update";
TMSLeaveDetails objleave = TMSLeaveDetails.Get(ID);
txtCLLeave.Text = objleave.LDCasualLeave.ToString();
txtPLLeave.Text = objleave.LDPaidLeave.ToString();
txtSLLeave.Text = objleave.LDSickLeave.ToString();
txtELLeave.Text = objleave.LDEarnedLeave.ToString();
txtOLLeave.Text = objleave.LDOtherLeave.ToString();
txtMaritalLeave.Text = objleave.LDMartialLeave.ToString();
txtMaternityLeave.Text = objleave.LDMartinityLeave.ToString();
DataTable dtCL = TMSLeaveAdvancedDetails.FillAdvaceLeave(ID, Convert.ToInt64(Session["AccountID"]), "CL", Session["type"].ToString()).Tables[0];
if (dtCL.Rows.Count > 0)
{
hiddenClID.Value = dtCL.Rows[0]["LAD_DetailsId"].ToString();
txtCLJan.Text = dtCL.Rows[0]["LAD_Jan"].ToString();
txtCLFeb.Text = dtCL.Rows[0]["LAD_Feb"].ToString();
txtCLMar.Text = dtCL.Rows[0]["LAD_Mar"].ToString();
txtCLApr.Text = dtCL.Rows[0]["LAD_Apr"].ToString();
txtCLMay.Text = dtCL.Rows[0]["LAD_May"].ToString();
txtCLJun.Text = dtCL.Rows[0]["LAD_June"].ToString();
txtCLJul.Text = dtCL.Rows[0]["LAD_July"].ToString();
txtCLAug.Text = dtCL.Rows[0]["LAD_Aug"].ToString();
txtCLSep.Text = dtCL.Rows[0]["LAD_Sep"].ToString();
txtCLOct.Text = dtCL.Rows[0]["LAD_Oct"].ToString();
txtCLNov.Text = dtCL.Rows[0]["LAD_Nov"].ToString();
txtCLDec.Text = dtCL.Rows[0]["LAD_Dec"].ToString();
}
DataTable dtPL = TMSLeaveAdvancedDetails.FillAdvaceLeave(ID, Convert.ToInt64(Session["AccountID"]), "PL", Session["type"].ToString()).Tables[0];
if (dtPL.Rows.Count > 0)
{
hiddPLID.Value = dtPL.Rows[0]["LAD_DetailsId"].ToString();
txtPLJan.Text = dtPL.Rows[0]["LAD_Jan"].ToString();
txtPLFeb.Text = dtPL.Rows[0]["LAD_Feb"].ToString();
txtPLMar.Text = dtPL.Rows[0]["LAD_Mar"].ToString();
txtPLApr.Text = dtPL.Rows[0]["LAD_Apr"].ToString();
txtPLMay.Text = dtPL.Rows[0]["LAD_May"].ToString();
txtPLJun.Text = dtPL.Rows[0]["LAD_June"].ToString();
txtPLJul.Text = dtPL.Rows[0]["LAD_July"].ToString();
txtPLAug.Text = dtPL.Rows[0]["LAD_Aug"].ToString();
txtPLSep.Text = dtPL.Rows[0]["LAD_Sep"].ToString();
txtPLOct.Text = dtPL.Rows[0]["LAD_Oct"].ToString();
txtPLNov.Text = dtPL.Rows[0]["LAD_Nov"].ToString();
txtPLDec.Text = dtPL.Rows[0]["LAD_Dec"].ToString();
}
DataTable dtSL = TMSLeaveAdvancedDetails.FillAdvaceLeave(ID, Convert.ToInt64(Session["AccountID"]), "SL", Session["type"].ToString()).Tables[0];
if (dtSL.Rows.Count > 0)
{
hiddSLID.Value = dtSL.Rows[0]["LAD_DetailsId"].ToString();
txtSLJan.Text = dtSL.Rows[0]["LAD_Jan"].ToString();
txtSLFeb.Text = dtSL.Rows[0]["LAD_Feb"].ToString();
txtSLMar.Text = dtSL.Rows[0]["LAD_Mar"].ToString();
txtSLApr.Text = dtSL.Rows[0]["LAD_Apr"].ToString();
txtSLMay.Text = dtSL.Rows[0]["LAD_May"].ToString();
txtSLJun.Text = dtSL.Rows[0]["LAD_June"].ToString();
txtSLJul.Text = dtSL.Rows[0]["LAD_July"].ToString();
txtSLAug.Text = dtSL.Rows[0]["LAD_Aug"].ToString();
txtSLSep.Text = dtSL.Rows[0]["LAD_Sep"].ToString();
txtSLOct.Text = dtSL.Rows[0]["LAD_Oct"].ToString();
txtSLNov.Text = dtSL.Rows[0]["LAD_Nov"].ToString();
txtSLDec.Text = dtSL.Rows[0]["LAD_Dec"].ToString();
}
DataTable dtEL = TMSLeaveAdvancedDetails.FillAdvaceLeave(ID, Convert.ToInt64(Session["AccountID"]), "EL", Session["type"].ToString()).Tables[0];
if (dtEL.Rows.Count > 0)
{
hiddELID.Value = dtEL.Rows[0]["LAD_DetailsId"].ToString();
txtELJan.Text = dtEL.Rows[0]["LAD_Jan"].ToString();
txtELFeb.Text = dtEL.Rows[0]["LAD_Feb"].ToString();
txtELMar.Text = dtEL.Rows[0]["LAD_Mar"].ToString();
txtELApr.Text = dtEL.Rows[0]["LAD_Apr"].ToString();
txtELMay.Text = dtEL.Rows[0]["LAD_May"].ToString();
txtELJun.Text = dtEL.Rows[0]["LAD_June"].ToString();
txtELJul.Text = dtEL.Rows[0]["LAD_July"].ToString();
txtELAug.Text = dtEL.Rows[0]["LAD_Aug"].ToString();
txtELSep.Text = dtEL.Rows[0]["LAD_Sep"].ToString();
txtELOct.Text = dtEL.Rows[0]["LAD_Oct"].ToString();
txtELNov.Text = dtEL.Rows[0]["LAD_Nov"].ToString();
txtELDec.Text = dtEL.Rows[0]["LAD_Dec"].ToString();
}
}
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (btnsave.Text == "Update")
{
TMSLeaveDetails objleave = TMSLeaveDetails.Get(Convert.ToInt64(hiddLeaveID.Value));
objleave.LDCasualLeave = Convert.ToInt32(txtCLLeave.Text);
objleave.LDPaidLeave = Convert.ToInt32(txtPLLeave.Text);
objleave.LDSickLeave = Convert.ToInt32(txtSLLeave.Text);
objleave.LDEarnedLeave = Convert.ToInt32(txtELLeave.Text);
objleave.LDOtherLeave = Convert.ToInt32(txtOLLeave.Text);
objleave.LDMartialLeave = Convert.ToInt32(txtMaritalLeave.Text);
objleave.LDMartinityLeave = Convert.ToInt32(txtMaternityLeave.Text);
objleave.LDFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objleave.LDFacultyType = Session["type"].ToString();
objleave.LDAddedById = Convert.ToInt64(Session["UserId"]);
objleave.LDDate = DateTime.Now;
// objleave.LDYear = DateTime.Now.Yearn.ToString ();
objleave.LDStatus = 1;
objleave.Insert();
TMSLeaveAdvancedDetails objadv = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddenClID.Value));
objadv.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv.LADLeaveType = "CL";
objadv.LADJan = Convert.ToInt32(txtCLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtCLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtCLMar.Text);
objadv.LADApr = Convert.ToInt32(txtCLApr.Text);
objadv.LADMay = Convert.ToInt32(txtCLMay.Text);
objadv.LADJune = Convert.ToInt32(txtCLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtCLJul.Text);
objadv.LADAug = Convert.ToInt32(txtCLAug.Text);
objadv.LADSep = Convert.ToInt32(txtCLSep.Text);
objadv.LADOct = Convert.ToInt32(txtCLOct.Text);
objadv.LADNov = Convert.ToInt32(txtCLNov.Text);
objadv.LADDec = Convert.ToInt32(txtCLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Update();
TMSLeaveAdvancedDetails objadv2 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddPLID.Value));
objadv2.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv2.LADLeaveType = "PL";
objadv2.LADJan = Convert.ToInt32(txtPLJan.Text);
objadv2.LADFeb = Convert.ToInt32(txtPLFeb.Text);
objadv2.LADMar = Convert.ToInt32(txtPLMar.Text);
objadv2.LADApr = Convert.ToInt32(txtPLApr.Text);
objadv2.LADMay = Convert.ToInt32(txtPLMay.Text);
objadv2.LADJune = Convert.ToInt32(txtPLJun.Text);
objadv2.LADJuly = Convert.ToInt32(txtPLJul.Text);
objadv2.LADAug = Convert.ToInt32(txtPLAug.Text);
objadv2.LADSep = Convert.ToInt32(txtPLSep.Text);
objadv2.LADOct = Convert.ToInt32(txtPLOct.Text);
objadv2.LADNov = Convert.ToInt32(txtPLNov.Text);
objadv2.LADDec = Convert.ToInt32(txtPLDec.Text);
objadv2.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv2.LADFacultyType = Session["type"].ToString();
objadv2.LADDate = DateTime.Now;
objadv2.LADStatus = 1;
objadv2.Update();
TMSLeaveAdvancedDetails objadv3 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddSLID.Value));
objadv3.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv3.LADLeaveType = "SL";
objadv3.LADJan = Convert.ToInt32(txtSLJan.Text);
objadv3.LADFeb = Convert.ToInt32(txtSLFeb.Text);
objadv3.LADMar = Convert.ToInt32(txtSLMar.Text);
objadv3.LADApr = Convert.ToInt32(txtSLApr.Text);
objadv3.LADMay = Convert.ToInt32(txtSLMay.Text);
objadv3.LADJune = Convert.ToInt32(txtSLJun.Text);
objadv3.LADJuly = Convert.ToInt32(txtSLJul.Text);
objadv3.LADAug = Convert.ToInt32(txtSLAug.Text);
objadv3.LADSep = Convert.ToInt32(txtSLSep.Text);
objadv3.LADOct = Convert.ToInt32(txtSLOct.Text);
objadv3.LADNov = Convert.ToInt32(txtSLNov.Text);
objadv3.LADDec = Convert.ToInt32(txtSLDec.Text);
objadv3.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv3.LADFacultyType = Session["type"].ToString();
objadv3.LADDate = DateTime.Now;
objadv3.LADStatus = 1;
objadv3.Update();
TMSLeaveAdvancedDetails objadv4 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddELID.Value));
objadv4.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv4.LADLeaveType = "EL";
objadv4.LADJan = Convert.ToInt32(txtELJan.Text);
objadv4.LADFeb = Convert.ToInt32(txtELFeb.Text);
objadv4.LADMar = Convert.ToInt32(txtELMar.Text);
objadv4.LADApr = Convert.ToInt32(txtELApr.Text);
objadv4.LADMay = Convert.ToInt32(txtELMay.Text);
objadv4.LADJune = Convert.ToInt32(txtELJun.Text);
objadv4.LADJuly = Convert.ToInt32(txtELJul.Text);
objadv4.LADAug = Convert.ToInt32(txtELAug.Text);
objadv4.LADSep = Convert.ToInt32(txtELSep.Text);
objadv4.LADOct = Convert.ToInt32(txtELOct.Text);
objadv4.LADNov = Convert.ToInt32(txtELNov.Text);
objadv4.LADDec = Convert.ToInt32(txtELDec.Text);
objadv4.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv4.LADFacultyType = Session["type"].ToString();
objadv4.LADDate = DateTime.Now;
objadv4.LADStatus = 1;
objadv4.Update();
dvMsg.Visible = true;
lblMessage.Text = "Leave Account Updated Successfully !";
dvMsg.Attributes.Add("class", "warring_msg");
}
else
{
TMSLeaveDetails objleave = new TMSLeaveDetails();
objleave.LDCasualLeave = Convert.ToInt32(txtCLLeave.Text);
objleave.LDPaidLeave = Convert.ToInt32(txtPLLeave.Text);
objleave.LDSickLeave = Convert.ToInt32(txtSLLeave.Text);
objleave.LDEarnedLeave = Convert.ToInt32(txtELLeave.Text);
objleave.LDOtherLeave = Convert.ToInt32(txtOLLeave.Text);
objleave.LDMartialLeave = Convert.ToInt32(txtMaritalLeave.Text);
objleave.LDMartinityLeave = Convert.ToInt32(txtMaternityLeave.Text);
objleave.LDFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objleave.LDFacultyType = Session["type"].ToString();
objleave.LDAddedById = Convert.ToInt64(Session["UserId"]);
objleave.LDDate = DateTime.Now;
// objleave.LDYear = DateTime.Now.Yearn.ToString ();
objleave.LDStatus = 1;
objleave.Insert();
TMSLeaveAdvancedDetails objadv = new TMSLeaveAdvancedDetails();
objadv.LADLeaveType = "CL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtCLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtCLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtCLMar.Text);
objadv.LADApr = Convert.ToInt32(txtCLApr.Text);
objadv.LADMay = Convert.ToInt32(txtCLMay.Text);
objadv.LADJune = Convert.ToInt32(txtCLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtCLJul.Text);
objadv.LADAug = Convert.ToInt32(txtCLAug.Text);
objadv.LADSep = Convert.ToInt32(txtCLSep.Text);
objadv.LADOct = Convert.ToInt32(txtCLOct.Text);
objadv.LADNov = Convert.ToInt32(txtCLNov.Text);
objadv.LADDec = Convert.ToInt32(txtCLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "PL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtPLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtPLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtPLMar.Text);
objadv.LADApr = Convert.ToInt32(txtPLApr.Text);
objadv.LADMay = Convert.ToInt32(txtPLMay.Text);
objadv.LADJune = Convert.ToInt32(txtPLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtPLJul.Text);
objadv.LADAug = Convert.ToInt32(txtPLAug.Text);
objadv.LADSep = Convert.ToInt32(txtPLSep.Text);
objadv.LADOct = Convert.ToInt32(txtPLOct.Text);
objadv.LADNov = Convert.ToInt32(txtPLNov.Text);
objadv.LADDec = Convert.ToInt32(txtPLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "SL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtSLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtSLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtSLMar.Text);
objadv.LADApr = Convert.ToInt32(txtSLApr.Text);
objadv.LADMay = Convert.ToInt32(txtSLMay.Text);
objadv.LADJune = Convert.ToInt32(txtSLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtSLJul.Text);
objadv.LADAug = Convert.ToInt32(txtSLAug.Text);
objadv.LADSep = Convert.ToInt32(txtSLSep.Text);
objadv.LADOct = Convert.ToInt32(txtSLOct.Text);
objadv.LADNov = Convert.ToInt32(txtSLNov.Text);
objadv.LADDec = Convert.ToInt32(txtSLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "EL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtELJan.Text);
objadv.LADFeb = Convert.ToInt32(txtELFeb.Text);
objadv.LADMar = Convert.ToInt32(txtELMar.Text);
objadv.LADApr = Convert.ToInt32(txtELApr.Text);
objadv.LADMay = Convert.ToInt32(txtELMay.Text);
objadv.LADJune = Convert.ToInt32(txtELJun.Text);
objadv.LADJuly = Convert.ToInt32(txtELJul.Text);
objadv.LADAug = Convert.ToInt32(txtELAug.Text);
objadv.LADSep = Convert.ToInt32(txtELSep.Text);
objadv.LADOct = Convert.ToInt32(txtELOct.Text);
objadv.LADNov = Convert.ToInt32(txtELNov.Text);
objadv.LADDec = Convert.ToInt32(txtELDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
dvMsg.Visible = true;
lblMessage.Text = "Leave Account Added Successfully !";
dvMsg.Attributes.Add("class", "warring_msg");
}
}
catch { }
}
protected void btnsave_Click(object sender, EventArgs e)
{
try
{
if (btnsave.Text == "Update")
{
TMSLeaveDetails objleave = TMSLeaveDetails.Get(Convert.ToInt64(hiddLeaveID.Value));
objleave.LDCasualLeave = Convert.ToInt32(txtCLLeave.Text);
objleave.LDPaidLeave = Convert.ToInt32(txtPLLeave.Text);
objleave.LDSickLeave = Convert.ToInt32(txtSLLeave.Text);
objleave.LDEarnedLeave = Convert.ToInt32(txtELLeave.Text);
objleave.LDOtherLeave = Convert.ToInt32(txtOLLeave.Text);
objleave.LDMartialLeave = Convert.ToInt32(txtMaritalLeave.Text);
objleave.LDMartinityLeave = Convert.ToInt32(txtMaternityLeave.Text);
objleave.LDFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objleave.LDFacultyType = Session["type"].ToString();
objleave.LDAddedById = Convert.ToInt64(Session["UserId"]);
objleave.LDDate = DateTime.Now;
// objleave.LDYear = DateTime.Now.Yearn.ToString ();
objleave.LDStatus = 1;
objleave.Insert();
TMSLeaveAdvancedDetails objadv = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddenClID.Value));
objadv.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv.LADLeaveType = "CL";
objadv.LADJan = Convert.ToInt32(txtCLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtCLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtCLMar.Text);
objadv.LADApr = Convert.ToInt32(txtCLApr.Text);
objadv.LADMay = Convert.ToInt32(txtCLMay.Text);
objadv.LADJune = Convert.ToInt32(txtCLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtCLJul.Text);
objadv.LADAug = Convert.ToInt32(txtCLAug.Text);
objadv.LADSep = Convert.ToInt32(txtCLSep.Text);
objadv.LADOct = Convert.ToInt32(txtCLOct.Text);
objadv.LADNov = Convert.ToInt32(txtCLNov.Text);
objadv.LADDec = Convert.ToInt32(txtCLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Update();
TMSLeaveAdvancedDetails objadv2 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddPLID.Value));
objadv2.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv2.LADLeaveType = "PL";
objadv2.LADJan = Convert.ToInt32(txtPLJan.Text);
objadv2.LADFeb = Convert.ToInt32(txtPLFeb.Text);
objadv2.LADMar = Convert.ToInt32(txtPLMar.Text);
objadv2.LADApr = Convert.ToInt32(txtPLApr.Text);
objadv2.LADMay = Convert.ToInt32(txtPLMay.Text);
objadv2.LADJune = Convert.ToInt32(txtPLJun.Text);
objadv2.LADJuly = Convert.ToInt32(txtPLJul.Text);
objadv2.LADAug = Convert.ToInt32(txtPLAug.Text);
objadv2.LADSep = Convert.ToInt32(txtPLSep.Text);
objadv2.LADOct = Convert.ToInt32(txtPLOct.Text);
objadv2.LADNov = Convert.ToInt32(txtPLNov.Text);
objadv2.LADDec = Convert.ToInt32(txtPLDec.Text);
objadv2.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv2.LADFacultyType = Session["type"].ToString();
objadv2.LADDate = DateTime.Now;
objadv2.LADStatus = 1;
objadv2.Update();
TMSLeaveAdvancedDetails objadv3 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddSLID.Value));
objadv3.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv3.LADLeaveType = "SL";
objadv3.LADJan = Convert.ToInt32(txtSLJan.Text);
objadv3.LADFeb = Convert.ToInt32(txtSLFeb.Text);
objadv3.LADMar = Convert.ToInt32(txtSLMar.Text);
objadv3.LADApr = Convert.ToInt32(txtSLApr.Text);
objadv3.LADMay = Convert.ToInt32(txtSLMay.Text);
objadv3.LADJune = Convert.ToInt32(txtSLJun.Text);
objadv3.LADJuly = Convert.ToInt32(txtSLJul.Text);
objadv3.LADAug = Convert.ToInt32(txtSLAug.Text);
objadv3.LADSep = Convert.ToInt32(txtSLSep.Text);
objadv3.LADOct = Convert.ToInt32(txtSLOct.Text);
objadv3.LADNov = Convert.ToInt32(txtSLNov.Text);
objadv3.LADDec = Convert.ToInt32(txtSLDec.Text);
objadv3.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv3.LADFacultyType = Session["type"].ToString();
objadv3.LADDate = DateTime.Now;
objadv3.LADStatus = 1;
objadv3.Update();
TMSLeaveAdvancedDetails objadv4 = TMSLeaveAdvancedDetails.Get(Convert.ToInt64(hiddELID.Value));
objadv4.LADLeaveDetailId = Convert.ToInt64(hiddLeaveID.Value);
objadv4.LADLeaveType = "EL";
objadv4.LADJan = Convert.ToInt32(txtELJan.Text);
objadv4.LADFeb = Convert.ToInt32(txtELFeb.Text);
objadv4.LADMar = Convert.ToInt32(txtELMar.Text);
objadv4.LADApr = Convert.ToInt32(txtELApr.Text);
objadv4.LADMay = Convert.ToInt32(txtELMay.Text);
objadv4.LADJune = Convert.ToInt32(txtELJun.Text);
objadv4.LADJuly = Convert.ToInt32(txtELJul.Text);
objadv4.LADAug = Convert.ToInt32(txtELAug.Text);
objadv4.LADSep = Convert.ToInt32(txtELSep.Text);
objadv4.LADOct = Convert.ToInt32(txtELOct.Text);
objadv4.LADNov = Convert.ToInt32(txtELNov.Text);
objadv4.LADDec = Convert.ToInt32(txtELDec.Text);
objadv4.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv4.LADFacultyType = Session["type"].ToString();
objadv4.LADDate = DateTime.Now;
objadv4.LADStatus = 1;
objadv4.Update();
dvMsg.Visible = true;
lblMessage.Text = "Leave Account Updated Successfully !";
dvMsg.Attributes.Add("class", "warring_msg");
}
else
{
TMSLeaveDetails objleave = new TMSLeaveDetails();
objleave.LDCasualLeave = Convert.ToInt32(txtCLLeave.Text);
objleave.LDPaidLeave = Convert.ToInt32(txtPLLeave.Text);
objleave.LDSickLeave = Convert.ToInt32(txtSLLeave.Text);
objleave.LDEarnedLeave = Convert.ToInt32(txtELLeave.Text);
objleave.LDOtherLeave = Convert.ToInt32(txtOLLeave.Text);
objleave.LDMartialLeave = Convert.ToInt32(txtMaritalLeave.Text);
objleave.LDMartinityLeave = Convert.ToInt32(txtMaternityLeave.Text);
objleave.LDFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objleave.LDFacultyType = Session["type"].ToString();
objleave.LDAddedById = Convert.ToInt64(Session["UserId"]);
objleave.LDDate = DateTime.Now;
// objleave.LDYear = DateTime.Now.Yearn.ToString ();
objleave.LDStatus = 1;
objleave.Insert();
TMSLeaveAdvancedDetails objadv = new TMSLeaveAdvancedDetails();
objadv.LADLeaveType = "CL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtCLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtCLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtCLMar.Text);
objadv.LADApr = Convert.ToInt32(txtCLApr.Text);
objadv.LADMay = Convert.ToInt32(txtCLMay.Text);
objadv.LADJune = Convert.ToInt32(txtCLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtCLJul.Text);
objadv.LADAug = Convert.ToInt32(txtCLAug.Text);
objadv.LADSep = Convert.ToInt32(txtCLSep.Text);
objadv.LADOct = Convert.ToInt32(txtCLOct.Text);
objadv.LADNov = Convert.ToInt32(txtCLNov.Text);
objadv.LADDec = Convert.ToInt32(txtCLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "PL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtPLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtPLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtPLMar.Text);
objadv.LADApr = Convert.ToInt32(txtPLApr.Text);
objadv.LADMay = Convert.ToInt32(txtPLMay.Text);
objadv.LADJune = Convert.ToInt32(txtPLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtPLJul.Text);
objadv.LADAug = Convert.ToInt32(txtPLAug.Text);
objadv.LADSep = Convert.ToInt32(txtPLSep.Text);
objadv.LADOct = Convert.ToInt32(txtPLOct.Text);
objadv.LADNov = Convert.ToInt32(txtPLNov.Text);
objadv.LADDec = Convert.ToInt32(txtPLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "SL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtSLJan.Text);
objadv.LADFeb = Convert.ToInt32(txtSLFeb.Text);
objadv.LADMar = Convert.ToInt32(txtSLMar.Text);
objadv.LADApr = Convert.ToInt32(txtSLApr.Text);
objadv.LADMay = Convert.ToInt32(txtSLMay.Text);
objadv.LADJune = Convert.ToInt32(txtSLJun.Text);
objadv.LADJuly = Convert.ToInt32(txtSLJul.Text);
objadv.LADAug = Convert.ToInt32(txtSLAug.Text);
objadv.LADSep = Convert.ToInt32(txtSLSep.Text);
objadv.LADOct = Convert.ToInt32(txtSLOct.Text);
objadv.LADNov = Convert.ToInt32(txtSLNov.Text);
objadv.LADDec = Convert.ToInt32(txtSLDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
objadv.LADLeaveType = "EL";
objadv.LADLeaveDetailId = objleave.LDLeaveDetailsId;
objadv.LADJan = Convert.ToInt32(txtELJan.Text);
objadv.LADFeb = Convert.ToInt32(txtELFeb.Text);
objadv.LADMar = Convert.ToInt32(txtELMar.Text);
objadv.LADApr = Convert.ToInt32(txtELApr.Text);
objadv.LADMay = Convert.ToInt32(txtELMay.Text);
objadv.LADJune = Convert.ToInt32(txtELJun.Text);
objadv.LADJuly = Convert.ToInt32(txtELJul.Text);
objadv.LADAug = Convert.ToInt32(txtELAug.Text);
objadv.LADSep = Convert.ToInt32(txtELSep.Text);
objadv.LADOct = Convert.ToInt32(txtELOct.Text);
objadv.LADNov = Convert.ToInt32(txtELNov.Text);
objadv.LADDec = Convert.ToInt32(txtELDec.Text);
objadv.LADFacultyLoginId = Convert.ToInt64(Session["AccountID"]);
objadv.LADFacultyType = Session["type"].ToString();
objadv.LADDate = DateTime.Now;
objadv.LADStatus = 1;
objadv.Insert();
dvMsg.Visible = true;
lblMessage.Text = "Leave Account Added Successfully !";
dvMsg.Attributes.Add("class", "warring_msg");
}
}
catch { }
}
public static void Update(TMSLeaveDetails tMSLeaveDetails, DbTransaction transaction)
{
tMSLeaveDetails.Update(transaction);
}
public static void Update(TMSLeaveDetails tMSLeaveDetails)
{
tMSLeaveDetails.Update();
}
public static TMSLeaveDetails[] MapFrom(DataSet ds)
{
List<TMSLeaveDetails> objects;
// Initialise Collection.
objects = new List<TMSLeaveDetails>();
// Validation.
if (ds == null)
throw new ApplicationException("Cannot map to dataset null.");
else if (ds.Tables[TABLE_NAME].Rows.Count == 0)
return objects.ToArray();
if (ds.Tables[TABLE_NAME] == null)
throw new ApplicationException("Cannot find table [dbo].[TMS_LeaveDetails] in DataSet.");
if (ds.Tables[TABLE_NAME].Rows.Count < 1)
throw new ApplicationException("Table [dbo].[TMS_LeaveDetails] is empty.");
// Map DataSet to Instance.
foreach (DataRow dr in ds.Tables[TABLE_NAME].Rows)
{
TMSLeaveDetails instance = new TMSLeaveDetails();
instance.MapFrom(dr);
objects.Add(instance);
}
// Return collection.
return objects.ToArray();
}
public static TMSLeaveDetails Get(System.Int64 ldLeaveDetailsId)
{
DataSet ds;
Database db;
string sqlCommand;
DbCommand dbCommand;
TMSLeaveDetails instance;
instance = new TMSLeaveDetails();
db = DatabaseFactory.CreateDatabase();
sqlCommand = "[dbo].gspTMSLeaveDetails_SELECT";
dbCommand = db.GetStoredProcCommand(sqlCommand, ldLeaveDetailsId);
// Get results.
ds = db.ExecuteDataSet(dbCommand);
// Verification.
if (ds == null || ds.Tables[0].Rows.Count == 0) throw new ApplicationException("Could not get TMSLeaveDetails ID:" + ldLeaveDetailsId.ToString()+ " from Database.");
// Return results.
ds.Tables[0].TableName = TABLE_NAME;
instance.MapFrom( ds.Tables[0].Rows[0] );
return instance;
}
