public DataSet AuthinticateManager(Attendance.Entities.Entities entities) { DataSet dsManagerLogin = new DataSet(); try { SqlDataAdapter daManager = new SqlDataAdapter("[USP_Manager]", connectionString); daManager.SelectCommand.Parameters.Add(new SqlParameter("@EMPID", entities.EMPID)); daManager.SelectCommand.Parameters.Add(new SqlParameter("@LocationName", entities.LocationName)); daManager.SelectCommand.Parameters.Add(new SqlParameter("@PassCode", entities.passcode)); daManager.SelectCommand.Parameters.Add(new SqlParameter("@UserID", entities.UserID)); daManager.SelectCommand.CommandType = CommandType.StoredProcedure; daManager.Fill(dsManagerLogin); return(dsManagerLogin); } catch (Exception ex) { throw ex; } }
public DataSet SaveLogoutDetails(Attendance.Entities.Entities objEntity, int UserLogID) { DataSet dsLogoutDet = new DataSet(); try { SqlDataAdapter daLogout = new SqlDataAdapter("[USP_AddLogout]", connectionString); daLogout.SelectCommand.Parameters.Add(new SqlParameter("@UserID", objEntity.UserID)); daLogout.SelectCommand.Parameters.Add(new SqlParameter("@loguserID", UserLogID)); daLogout.SelectCommand.Parameters.Add(new SqlParameter("@LogOutDate", objEntity.LogOutDate)); daLogout.SelectCommand.Parameters.Add(new SqlParameter("@LogOutNotes", objEntity.LogOutNotes)); daLogout.SelectCommand.CommandType = CommandType.StoredProcedure; daLogout.Fill(dsLogoutDet); return(dsLogoutDet); } catch (Exception ex) { throw ex; } }
public DataSet SaveLogDetails(Attendance.Entities.Entities entities) { DataSet dsLoginDet = new DataSet(); try { SqlDataAdapter daLogin = new SqlDataAdapter("[USP_AddLogin1]", connectionString); daLogin.SelectCommand.Parameters.Add(new SqlParameter("@UserID", entities.UserID)); daLogin.SelectCommand.Parameters.Add(new SqlParameter("@passcode", entities.passcode)); daLogin.SelectCommand.Parameters.Add(new SqlParameter("@LoginDate", Convert.ToDateTime((entities.LoginDate)))); daLogin.SelectCommand.Parameters.Add(new SqlParameter("@LoginNotes", entities.LoginNotes)); daLogin.SelectCommand.CommandType = CommandType.StoredProcedure; daLogin.Fill(dsLoginDet); return(dsLoginDet); } catch (Exception ex) { throw ex; } return(dsLoginDet); }
public void SaveManagerDetails(Attendance.Entities.Entities entities) { try { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("USP_AddIP", con); cmd.CommandType = CommandType.StoredProcedure; con.Open(); cmd.Parameters.AddWithValue("@LocationName", entities.LocationName); cmd.Parameters.AddWithValue("@PassCode", entities.passcode); cmd.Parameters.AddWithValue("@EMPID", entities.EMPID); cmd.Parameters.AddWithValue("@IpAddress", entities.IpAddress); cmd.Parameters.AddWithValue("@CurrentDate", entities.StartTime); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { throw ex; } }
public void UpdateIP(Attendance.Entities.Entities entities) { try { SqlConnection con = new SqlConnection(connectionString); SqlCommand cmd = new SqlCommand("[USP_UpdateIP]", con); cmd.CommandType = CommandType.StoredProcedure; //cmd.CommandText = (); con.Open(); //cmd.Parameters.AddWithValue("@FirstName",entities.FirstName); cmd.Parameters.AddWithValue("@LocationName", entities.LocationName); cmd.Parameters.AddWithValue("@CurrentDate", entities.StartTime); cmd.Parameters.AddWithValue("@EMPID", entities.EMPID); cmd.Parameters.AddWithValue("@IpAddress", entities.IpAddress); cmd.ExecuteNonQuery(); con.Close(); } catch (Exception ex) { throw ex; } }