public DataResultArgs <List <PaymentEntity> > Get_PaymentForCurrentMonth() { DataProcess.ControlAdminAuthorization(); DataResultArgs <List <PaymentEntity> > resultSet = new DataResultArgs <List <PaymentEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "Get_PaymentForCurrentMonth"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { List <PaymentEntity> lst = GetList(result); resultSet.Result = lst; } con.Close(); } return(resultSet); }
public DataResultArgs <List <PaymentEntity> > Get_Payment(int studentId, string year) { DataProcess.ControlAdminAuthorization(); DataResultArgs <List <PaymentEntity> > resultSet = new DataResultArgs <List <PaymentEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@studentId", studentId); cmd.Parameters.AddWithValue("@year", year); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_Payment"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { List <PaymentEntity> lst = GetList(result); resultSet.Result = lst; } con.Close(); } return(resultSet); }
private static List <PaymentEntity> GetList(DataResultArgs <SqlDataReader> result) { DataProcess.ControlAdminAuthorization(); SqlDataReader dr = result.Result; List <PaymentEntity> lst = new List <PaymentEntity>(); while (dr.Read()) { var paymentEntity = new PaymentEntity { Id = GeneralFunctions.GetData <Int32>(dr["id"]), StudentId = GeneralFunctions.GetData <Int32?>(dr["studentId"]), Year = GeneralFunctions.GetData <Int16?>(dr["year"]), Month = GeneralFunctions.GetData <Int16?>(dr["month"]), Amount = GeneralFunctions.GetData <Decimal?>(dr["amount"]), IsPayment = GeneralFunctions.GetData <Boolean?>(dr["isPayment"]), PaymentDate = GeneralFunctions.GetData <DateTime?>(dr["paymentDate"]), PaymentType = GeneralFunctions.GetData <Int32?>(dr["paymentType"]), IsActive = GeneralFunctions.GetData <Boolean?>(dr["isActive"]), IsNotPayable = GeneralFunctions.GetData <Boolean>(dr["isNotPayable"]) }; lst.Add(paymentEntity); } dr.Close(); return(lst); }
public DataResultArgs <bool> Set_Admin(AdminEntity entity) { try { DataProcess.ControlAdminAuthorization(true); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DatabaseProcess", entity.DatabaseProcess); cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@userName", entity.UserName); cmd.Parameters.AddWithValue("@password", entity.Password); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@LastLoginDate", entity.LastLoginDate); cmd.Parameters.AddWithValue("@AdminType", entity.AdminType); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <bool> resultSet = DataProcess.ExecuteProc(con, cmd, "set_Admin"); con.Close(); return(resultSet); } } catch (Exception e) { DataResultArgs <bool> result = new DataResultArgs <bool>(); result.HasError = true; result.ErrorDescription = e.Message; return(result); } }
private static void GetList(SqlCommand cmd, DataResultArgs <List <AdminEntity> > resultSet) { using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_Admin"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { SqlDataReader dr = result.Result; List <AdminEntity> lst = new List <AdminEntity>(); AdminEntity elist; while (dr.Read()) { elist = new AdminEntity(); elist.Id = GeneralFunctions.GetData <Int32>(dr["id"]); elist.UserName = GeneralFunctions.GetData <String>(dr["userName"]); elist.Password = GeneralFunctions.GetData <String>(dr["password"]); elist.IsActive = GeneralFunctions.GetData <Boolean?>(dr["isActive"]); elist.LastLoginDate = GeneralFunctions.GetData <DateTime?>(dr["LastLoginDate"]); elist.AdminType = GeneralFunctions.GetData <Int16?>(dr["AdminType"]); lst.Add(elist); } dr.Close(); resultSet.Result = lst; } con.Close(); } }
public DataResultArgs <bool> Set_PaymentType(PaymentTypeEntity entity) { try { DataProcess.ControlAdminAuthorization(true); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DatabaseProcess", entity.DatabaseProcess); cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@name", entity.Name); cmd.Parameters.AddWithValue("@amount", entity.Amount); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <bool> resultSet = DataProcess.ExecuteProc(con, cmd, "set_PaymentType"); con.Close(); staticPaymentTypeList = null; return(resultSet); } } catch (Exception ex) { DataResultArgs <bool> result = new DataResultArgs <bool>(); result.HasError = true; result.ErrorDescription = ex.Message; return(result); } }
public DataResultArgs <List <PaymentTypeEntity> > Get_PaymentType(SearchEntity entity) { DataProcess.ControlAdminAuthorization(); if (staticPaymentTypeList == null) { DataResultArgs <List <PaymentTypeEntity> > resultSet = new DataResultArgs <List <PaymentTypeEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isDeleted", entity.IsDeleted); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_PaymentType"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { SqlDataReader dr = result.Result; List <PaymentTypeEntity> lst = new List <PaymentTypeEntity>(); PaymentTypeEntity elist; while (dr.Read()) { elist = new PaymentTypeEntity(); elist.Id = GeneralFunctions.GetData <Int32>(dr["id"]); elist.Name = GeneralFunctions.GetData <String>(dr["name"]); elist.Amount = GeneralFunctions.GetData <Decimal?>(dr["amount"]); elist.IsActive = GeneralFunctions.GetData <Boolean?>(dr["isActive"]); elist.UpdatedOn = GeneralFunctions.GetData <DateTime>(dr["updatedOn"]); lst.Add(elist); } dr.Close(); resultSet.Result = lst; } con.Close(); } staticPaymentTypeList = resultSet; } return(staticPaymentTypeList); }
public DataResultArgs <PaymentTypeEntity> Get_PaymentTypeWithId(int id) { DataProcess.ControlAdminAuthorization(); DataResultArgs <List <PaymentTypeEntity> > resultSet = Get_PaymentType(new SearchEntity() { IsActive = true, IsDeleted = false }); DataResultArgs <PaymentTypeEntity> result = new DataResultArgs <PaymentTypeEntity>(); EntityHelper.CopyDataResultArgs <PaymentTypeEntity>(resultSet, result); result.Result = resultSet.Result.FirstOrDefault(o => o.Id == id); return(result); }
public DataResultArgs <List <StudentEntity> > Get_Student(SearchEntity entity) { DataProcess.ControlAdminAuthorization(); DataResultArgs <List <StudentEntity> > resultSet = new DataResultArgs <List <StudentEntity> >(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isDeleted", entity.IsDeleted); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_Student"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { SqlDataReader dr = result.Result; List <StudentEntity> lst = new List <StudentEntity>(); while (dr.Read()) { var studentEntity = GetEntity(dr); lst.Add(studentEntity); } dr.Close(); resultSet.Result = lst; } con.Close(); } return(resultSet); }
public StudentEntity Get_StudentWithPaymentList(int id) { DataProcess.ControlAdminAuthorization(); StudentEntity entity = Get_Student(new SearchEntity() { Id = id }).Result[0]; DataResultArgs <List <PaymentEntity> > paymentListResult = new PaymentBusiness().Get_Payment(entity.Id, DateTime.Today.Year.ToString()); if (!paymentListResult.HasError) { if (paymentListResult.Result.Any()) { entity.PaymentList = paymentListResult.Result; } } return(entity); }
public DataResultArgs <StudentEntity> Get_Student(string citizenshipNumber) { DataProcess.ControlAdminAuthorization(); DataResultArgs <StudentEntity> resultSet = new DataResultArgs <StudentEntity>(); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@citizenshipNumber", citizenshipNumber); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <SqlDataReader> result = DataProcess.ExecuteProcDataReader(con, cmd, "get_Student"); if (result.HasError) { resultSet.HasError = result.HasError; resultSet.ErrorDescription = result.ErrorDescription; resultSet.ErrorCode = result.ErrorCode; } else { SqlDataReader dr = result.Result; StudentEntity elist; while (dr.Read()) { elist = GetEntity(dr); resultSet.Result = elist; } dr.Close(); } con.Close(); } return(resultSet); }
public DataResultArgs <string> Set_Payment(PaymentEntity entity) { try { DataProcess.ControlAdminAuthorization(true); SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DatabaseProcess", entity.DatabaseProcess); cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@studentId", entity.StudentId); cmd.Parameters.AddWithValue("@year", entity.Year); cmd.Parameters.AddWithValue("@month", entity.Month); cmd.Parameters.AddWithValue("@amount", entity.Amount); cmd.Parameters.AddWithValue("@isPayment", entity.IsPayment); cmd.Parameters.AddWithValue("@paymentDate", entity.PaymentDate); cmd.Parameters.AddWithValue("@paymentType", entity.PaymentType); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isNotPayable", entity.IsNotPayable); cmd.Parameters.AddWithValue("@isChangeAmountPaymentNotOK", entity.IsChangeAmountPaymentNotOK); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <string> resultSet = DataProcess.ExecuteProcString(con, cmd, "set_Payment"); con.Close(); return(resultSet); } } catch (Exception e) { DataResultArgs <string> result = new DataResultArgs <string>(); result.HasError = true; result.ErrorDescription = e.Message; return(result); } }
private static StudentEntity GetEntity(SqlDataReader dr) { DataProcess.ControlAdminAuthorization(); StudentEntity elist = new StudentEntity(); elist.Id = GeneralFunctions.GetData <Int32>(dr["id"]); elist.CitizenshipNumber = GeneralFunctions.GetData <String>(dr["citizenshipNumber"]); elist.Name = GeneralFunctions.GetData <String>(dr["name"]); elist.Surname = GeneralFunctions.GetData <String>(dr["surname"]); elist.MiddleName = GeneralFunctions.GetData <String>(dr["middleName"]); elist.FatherName = GeneralFunctions.GetData <String>(dr["fatherName"]); elist.MotherName = GeneralFunctions.GetData <String>(dr["motherName"]); elist.Birthday = GeneralFunctions.GetData <DateTime?>(dr["birthday"]); elist.FatherPhoneNumber = GeneralFunctions.GetData <String>(dr["fatherPhoneNumber"]); elist.MotherPhoneNumber = GeneralFunctions.GetData <String>(dr["motherPhoneNumber"]); elist.IsActive = GeneralFunctions.GetData <Boolean>(dr["isActive"]); elist.IsStudent = GeneralFunctions.GetData <Boolean>(dr["isStudent"]); elist.Notes = GeneralFunctions.GetData <String>(dr["notes"]); elist.DateOfMeeting = GeneralFunctions.GetData <DateTime?>(dr["dateOfMeeting"]); elist.SpokenPrice = GeneralFunctions.GetData <Decimal?>(dr["spokenPrice"]); elist.Email = GeneralFunctions.GetData <String>(dr["email"]); return(elist); }
public DataResultArgs <StudentEntity> Get_Student(int studentId) { DataProcess.ControlAdminAuthorization(); DataResultArgs <StudentEntity> resultSet = new DataResultArgs <StudentEntity>(); DataResultArgs <List <StudentEntity> > studentList = Get_Student(new SearchEntity() { Id = studentId }); if (studentList.HasError) { resultSet.HasError = studentList.HasError; resultSet.ErrorDescription = studentList.ErrorDescription; resultSet.MyException = studentList.MyException; } else { resultSet.Result = studentList.Result.FirstOrDefault(); } return(resultSet); }
public DataResultArgs <StudentEntity> Set_Student(StudentEntity entity) { try { DataProcess.ControlAdminAuthorization(true); if (entity.Id > 0 && entity.DatabaseProcess == DatabaseProcess.Add) { entity.DatabaseProcess = DatabaseProcess.Update; } DataResultArgs <StudentEntity> resultSet = new DataResultArgs <StudentEntity>(); resultSet.Result = entity; SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@DatabaseProcess", entity.DatabaseProcess); cmd.Parameters.AddWithValue("@id", entity.Id); cmd.Parameters.AddWithValue("@citizenshipNumber", entity.CitizenshipNumber); cmd.Parameters.AddWithValue("@name", entity.Name); cmd.Parameters.AddWithValue("@surname", entity.Surname); cmd.Parameters.AddWithValue("@middleName", entity.MiddleName); cmd.Parameters.AddWithValue("@fatherName", entity.FatherName); cmd.Parameters.AddWithValue("@motherName", entity.MotherName); cmd.Parameters.AddWithValue("@birthday", entity.Birthday); cmd.Parameters.AddWithValue("@fatherPhoneNumber", entity.FatherPhoneNumber); cmd.Parameters.AddWithValue("@motherPhoneNumber", entity.MotherPhoneNumber); cmd.Parameters.AddWithValue("@isActive", entity.IsActive); cmd.Parameters.AddWithValue("@isStudent", entity.IsStudent); cmd.Parameters.AddWithValue("@notes", entity.Notes); cmd.Parameters.AddWithValue("@dateOfMeeting", entity.DateOfMeeting); cmd.Parameters.AddWithValue("@spokenPrice", entity.SpokenPrice); cmd.Parameters.AddWithValue("@email", entity.Email); using (SqlConnection con = Connection.Conn) { con.Open(); DataResultArgs <string> currentResultSet = DataProcess.ExecuteProcString(con, cmd, "set_Student"); con.Close(); resultSet.HasError = currentResultSet.HasError; resultSet.ErrorDescription = currentResultSet.ErrorDescription; resultSet.MyException = currentResultSet.MyException; if (entity.DatabaseProcess == DatabaseProcess.Add && !currentResultSet.HasError) { resultSet.Result.Id = GeneralFunctions.GetData <Int32>(currentResultSet.Result); entity.Id = GeneralFunctions.GetData <Int32>(currentResultSet.Result); } } if (entity.IsAddAfterPaymentUnPayment) { List <PaymentTypeEntity> paymentTypeList = new PaymentTypeBusiness().Get_PaymentType(); foreach (PaymentTypeEntity paymentTypeEntity in paymentTypeList) { for (int i = 1; i < DateTime.Today.Month; i++) { PaymentEntity paymentEntity = new PaymentEntity(); paymentEntity.Id = 0; paymentEntity.DatabaseProcess = DatabaseProcess.Add; paymentEntity.Year = (short)DateTime.Today.Year; paymentEntity.StudentId = entity.Id; paymentEntity.IsNotPayable = true; paymentEntity.IsActive = true; paymentEntity.IsDeleted = false; paymentEntity.Month = (short)i; paymentEntity.IsPayment = false; paymentEntity.Amount = ((PaymentTypeEnum)paymentTypeEntity.Id == PaymentTypeEnum.Okul && entity.SpokenPrice.HasValue && entity.SpokenPrice.Value > 0) ? entity.SpokenPrice.Value : paymentTypeEntity.Amount; paymentEntity.PaymentType = paymentTypeEntity.Id; paymentEntity.AddedOn = DateTime.Now; new PaymentBusiness().Set_Payment(paymentEntity); } } } AllStudentWithCache = null; Get_AllStudentWithCache(); return(resultSet); } catch (Exception e) { DataResultArgs <StudentEntity> result = new DataResultArgs <StudentEntity>(); result.HasError = true; result.ErrorDescription = e.Message; return(result); } }