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