public List <HRM.PayRollDM.WorkDay> FillWorkDay(Int32 InstituteID)
{
SqlCommand com = null;
DataTable dt = new DataTable();
var listitem = new List <HRM.PayRollDM.WorkDay>();
SqlConnection cnx = new SqlConnection(ReturnConString());
com = new SqlCommand();
SqlDataReader dr;
cnx.Open();
com.Connection = cnx;
com.Parameters.AddWithValue("@flag", "S");
com.Parameters.AddWithValue("@InstituteID", InstituteID);
com.CommandType = CommandType.StoredProcedure;
com.CommandText = "SP_PayWorkDay";
dr = com.ExecuteReader();
while (dr.Read())
{
// var item = HRM.PayRoll.WorkingDay();
var item = new HRM.PayRollDM.WorkDay();
item.id = Int32.Parse(dr["id"].ToString());
item.yearID = Int32.Parse(dr["yearID"].ToString());
item.workDays = dr["workDays"].ToString();
item.InstituteID = Int32.Parse(dr["InstituteID"].ToString());
item.workdayid = Int32.Parse(dr["workdayID"].ToString());
item.frmdate = Convert.ToDateTime(dr["frmdate"]);
item.todate = Convert.ToDateTime(dr["todate"]);
item.cdate = Convert.ToDateTime(dr["cdate"]);
item.edate = Int32.Parse(dr["edate"].ToString());
item.mnth = Int32.Parse(dr["mnth"].ToString());
item.yr = Int32.Parse(dr["yr"].ToString());
item.deptID = Int32.Parse(dr["deptID"].ToString());
item.SessionF = dr["SessionF"].ToString();
listitem.Add(item);
}
dr.Close();
dr.Dispose();
return(listitem);
}
public string insertWorkDay(HRM.PayRollDM.WorkDay objWDay)
{
NewDAL.DBManager objDB = new DBManager();
objDB.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["FeesManagementConn"].ConnectionString;
objDB.DBManager(DataAccessLayer.DataProvider.SqlServer, objDB.ConnectionString);
string retv = string.Empty;
try
{
objDB.Open();
objDB.BeginTransaction();
string Retsuccess = string.Empty;
objDB.CreateParameters(16);
objDB.AddParameters(0, "id", objWDay.id, DbType.Int32);
//objDB.AddParameters(1, "mmonth", objWDay.mmonth, DbType.String);
objDB.AddParameters(1, "yearID", objWDay.yearID, DbType.Int32);
objDB.AddParameters(2, "workDays", objWDay.workDays, DbType.String);
objDB.AddParameters(3, "InstituteID", objWDay.InstituteID, DbType.Int32);
objDB.AddParameters(4, "workdayid", objWDay.workdayid, DbType.Int32);
objDB.AddParameters(5, "frmdate", objWDay.frmdate, DbType.DateTime);
objDB.AddParameters(6, "todate", objWDay.todate, DbType.DateTime);
objDB.AddParameters(7, "cdate", objWDay.cdate, DbType.DateTime);
objDB.AddParameters(8, "edate", objWDay.edate, DbType.Int32);
objDB.AddParameters(9, "mnth", objWDay.mnth, DbType.Int32);
objDB.AddParameters(10, "yr", objWDay.yr, DbType.Int32);
objDB.AddParameters(11, "flag", objWDay.flag, DbType.String);
objDB.AddParameters(12, "deptID", objWDay.deptID, DbType.Int32);
objDB.AddParameters(13, "UserID", objWDay.UserID, DbType.String);
objDB.AddParameters(14, "UEDate", objWDay.UEDate, DbType.DateTime);
objDB.AddParameters(15, "Retsuccess", 0, DbType.String, ParameterDirection.Output);
objDB.ExecuteNonQueryHR(CommandType.StoredProcedure, "SP_PayWorkDay");
Retsuccess = ((System.Data.SqlClient.SqlCommand)objDB.Command).Parameters["@RetSuccess"].Value.ToString();
objDB.Transaction.Commit();
if (Retsuccess == "1")
{
retv = "Record saved.";
}
else if (Retsuccess == "2")
{
retv = "Update successfuly.";
}
else if (Retsuccess == "3")
{
retv = "Delete successfully";
}
else if (Retsuccess == "4")
{
retv = "Record already exists.";
}
else if (Retsuccess == "5")
{
retv = "Record in used.";
}
}
catch (Exception ex)
{
objDB.Transaction.Rollback();
retv = "Unable to save record.";
}
return(retv);
}
