public DataSet GetAssignedBeats(EditPlanBO editPlanBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editPlanBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetAssignedBeats"; sqlHelper.AddParameter(command, "@UserId", editPlanBO.UserId, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public DataSet GetCustomerForBeat(EditPlanBO editPlanBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editPlanBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_GetCustomerForBeat"; sqlHelper.AddParameter(command, "@BeatPalnId", editPlanBO.BeatPlanId, ParameterDirection.Input); sqlHelper.AddParameter(command, "@date", editPlanBO.DateSet, ParameterDirection.Input); return(sqlHelper.ExecuteDataSet(command)); }
public void UpdateEditPlan(EditPlanBO editPlanBO) { DataAccessSqlHelper sqlHelper = new DataAccessSqlHelper(editPlanBO.ConString); SqlCommand command = sqlHelper.CreateCommand(CommandType.StoredProcedure); command.CommandText = "usp_UpdateEditplan"; sqlHelper.AddParameter(command, "@CustomerIdSet", editPlanBO.CustomerIdSet, ParameterDirection.Input); sqlHelper.AddParameter(command, "@DateSet", editPlanBO.DateSet, ParameterDirection.Input); sqlHelper.AddParameter(command, "@StatusSet", editPlanBO.StatusSet, ParameterDirection.Input); sqlHelper.AddParameter(command, "@UserIdSet", editPlanBO.UserIdSet, ParameterDirection.Input); sqlHelper.AddParameter(command, "@ApprovedDateSet", editPlanBO.ApprovedDateSet, ParameterDirection.Input); sqlHelper.ExecuteDataSet(command); }