public void AddStudentAttendance(List <StudentAttendance> entities) { try { Hashtable parameterlist; foreach (var entity in entities) { parameterlist = new Hashtable(); parameterlist.Add("@ClassId", entity.ClassId); parameterlist.Add("@DivisionId", entity.DivisionId); parameterlist.Add("@DateOfAttendance", entity.DateOfAttendance); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@AttendanceInDays", entity.AttendanceInDays); parameterlist.Add("@AbsentRemark", entity.AbsentRemark); Hashtable outparameterlist = new Hashtable(); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAttendanceInsert", parameterlist); } } catch (Exception ex) { throw; } }
public void Add(StudentLedger entity) { try { //string queryString = string.Format(" INSERT INTO [StudentLedger]([AcademicYearId],[StudentId],[TransactionDate],[FeeHeadId],[Cr],[Dr],[HeadBalance],[Balance],[ReceiptNo],[BankName],[ChequeNumber],[Status],[Remark],[CreatedBy],[CreatedDate],[ModifiedBy],[ModifiedDate]) VALUES({0}, '{1}', '{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}','{14}','{15}','{16}');" // , entity.AcademicYearId, entity.StudentId, entity.TransactionDate, entity.FeeHeadId, entity.Cr, entity.Dr, entity.HeadBalance, entity.Balance, entity.Status == true ? 1 : 0, entity.Remark, entity.CreatedBy, entity.CreatedDate, entity.ModifiedBy, entity.ModifiedDate); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@TransactionDate", entity.TransactionDate); parameterlist.Add("@FeeHeadId", entity.FeeHeadId); parameterlist.Add("@Cr", entity.Cr); parameterlist.Add("@Dr", entity.Dr); parameterlist.Add("@HeadBalance", entity.HeadBalance); parameterlist.Add("@Balance", entity.Balance); parameterlist.Add("@ReceiptNo", entity.ReceiptNo); parameterlist.Add("@BankName", entity.BankName); parameterlist.Add("@ChequeNumber", entity.ChequeNumber); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@CreatedBy", entity.CreatedBy); parameterlist.Add("@CreatedDate", entity.CreatedDate); parameterlist.Add("@ModifiedBy", entity.ModifiedBy); parameterlist.Add("@ModifiedDate", entity.ModifiedDate); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentLedgerInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(AcademicYear entity) { try { // string queryString = string.Format(" UPDATE [AcademicYearDetails] " + //" SET [AcademicYear] = '{0}'" + // ",[StartDate] = '{1}'" + // ",[EndDate] = '{2}'" + // ",[Status] = '{3}'" + // ",[Remark] = '{4}'" + //" WHERE AcademicYearId = {5};", entity.AcademicYearName, entity.StartDate, entity.EndDate, entity.Status, entity.Remark, entity.AcademicYearId); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@AcademicYearName", entity.AcademicYearName); parameterlist.Add("@StartDate", entity.StartDate); parameterlist.Add("@EndDate", entity.EndDate); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@AcademicYearId", entity.AcademicYearId); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_AcademicYearUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(FeeClassDivision entity) { try { // string queryString = string.Format(" UPDATE [FeeClassDivisionDetails] " + //" SET [AcademicYearId] = {0}" + // ",[FeeHeadId] = {1}" + // ",[ClassDivisionId] = {2}" + // ",[PeriodInMonthly] ={3}" + // ",[AmountInMonthly] = {4}" + // ",[AmountInYearly] = {5}" + // ",[Status] = {6}" + // ",[Remark] = '{7}'" + //" WHERE FeeClassDivisionId = {8};" //,entity.AcademicYearId, entity.FeeHeadId, entity.ClassDivisionId, entity.PeriodInMonthly, //entity.AmountInMonthly, entity.AmountInYearly, entity.Status == true ? 1 : 0, entity.Remark, entity.FeeClassDivisionId); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@FeeHeadId", entity.FeeHeadId); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@PeriodInMonthly", entity.PeriodInMonthly); parameterlist.Add("@AmountInMonthly", entity.AmountInMonthly); parameterlist.Add("@AmountInYearly", entity.AmountInYearly); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@FeeClassDivisionId", entity.FeeClassDivisionId); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_FeeClassDivisionUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(Religion entity) { try { // string queryString = string.Format(" UPDATE [ReligionDetails] " + //" SET [AcademicYearId] = {0}" + // ",[Religion] = '{1}'" + // ",[Status] = '{2}'" + // ",[Remark] = '{3}'" + //" WHERE [ReligionId] = {4};", entity.AcademicYearId, entity.ReligionName, entity.Status, entity.Remark, entity.ReligionId); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@Religion", entity.ReligionName); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@ReligionId", entity.ReligionId); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_ReligionDetailsUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void UpdateTCDetails(int StudentId) { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", StudentId); CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_UpdateStudentTCStatus", parameterlist); }
public void Edit(City entity) { try { // string queryString = string.Format(" UPDATE [CityDetails] " + //" SET [DistrictId] = {0}" + // ",[City] = '{1}'" + // ",[Status] = '{2}'" + // ",[Remark] = '{3}'" + //" WHERE CityId = {4};", entity.DistrictId, entity.CityName, entity.Status, entity.Remark, entity.CityId); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@CityId", entity.CityId); parameterlist.Add("@DistrictId", entity.DistrictId); parameterlist.Add("@City", entity.CityName); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_CityDetailsUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Add(Asset entity, int schoolId) { try { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@SchoolId", schoolId); parameterlist.Add("@TypeofAsset", entity.TypeofAsset); parameterlist.Add("@AssetName", entity.AssetName); parameterlist.Add("@Quantity", entity.Quantity); parameterlist.Add("@PricePerItem", entity.PricePerItem); parameterlist.Add("@Total", entity.Quantity * entity.PricePerItem);// entity.Total); parameterlist.Add("@PurchaseDate", entity.PurchaseDate); parameterlist.Add("@Condition", entity.Condition); parameterlist.Add("@AssesmentYear", entity.AssesmentYear); parameterlist.Add("@Status", entity.Status == true ? 1 : 0); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_InsertAssetDetails", parameterlist); } catch (Exception ex) { throw; } }
public void ChangePassword(User entity) { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@UserId", entity.UserId); parameterlist.Add("@Password", entity.Password); CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_ChangePassword", parameterlist); }
/// <summary> /// Add new student record /// </summary> /// <param name="entity">Student entity</param> /// <returns>Student Id</returns> public int AddStudent(Student entity, int SchoolId) { try { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@SchoolId", SchoolId); parameterlist.Add("@RegisterId", entity.RegisterId); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@Title", entity.Title); parameterlist.Add("@FirstName", entity.FirstName); parameterlist.Add("@MiddleName", entity.MiddleName); parameterlist.Add("@LastName", entity.LastName); parameterlist.Add("@MotherName", entity.MotherName); parameterlist.Add("@Gender", entity.Gender); parameterlist.Add("@Nationality", entity.Nationality); parameterlist.Add("@ReligionCastId", entity.ReligionCastId); parameterlist.Add("@DateOfBirth", entity.DateOfBirth); parameterlist.Add("@PlaceOfBirth", entity.PlaceOfBirth); parameterlist.Add("@AdharcardNo", entity.AdharcardNo); parameterlist.Add("@DateOfAdmission", entity.DateOfAdmission); parameterlist.Add("@MotherTounge", entity.MotherTounge); parameterlist.Add("@UStudentId", entity.UStudentId); parameterlist.Add("@LastSchoolAttended", entity.LastSchoolAttended); parameterlist.Add("@Progress", entity.Progress); parameterlist.Add("@Conduct", entity.Conduct); parameterlist.Add("@DateOfLeavingSchool", entity.DateOfLeavingSchool); parameterlist.Add("@LastSchoolClass", entity.LastSchoolClass); parameterlist.Add("@LastSchoolTCNo", entity.LastSchoolTCNo); parameterlist.Add("@ClassInWhichStudingAndSinceWhen", entity.ClassInWhichStudingAndSinceWhen); parameterlist.Add("@ReasonForLeavingSchool", entity.ReasonForLeavingSchool); parameterlist.Add("@RemarkOnTC", entity.RemarkOnTC); parameterlist.Add("@Status", entity.Status == true ? 1 : 0); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@PrevSchoolDateofLiving", entity.PrevSchoolDateofLiving); parameterlist.Add("@OUT_StudentId", null); Hashtable outparameterlist = new Hashtable(); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentInsert", parameterlist, ref outparameterlist); int studentId = 0; if (outparameterlist != null && outparameterlist.Count > 0) { foreach (string parametername in outparameterlist.Keys) { if (parametername.StartsWith("@OUT_")) { studentId = Convert.ToInt32(outparameterlist[parametername]); } } } return(studentId); } catch (Exception ex) { throw; } }
public void Add(StudentAddress entity) { try { //string queryString = string.Format(" INSERT INTO [StudentAddressDetails](" // +" [StudentId]" // +", [CurrentAddress]" // +", [CurrentCountryId]" // +", [CurrentStateId]" // +", [CurrentDistrictId]" // +", [CurrentCityId]" // +", [CurrentPinCode]" // +", [PermentAddress]" // +", [PermentCountryId]" // +", [PermentStateId]" // +", [PermentDistrictId]" // +", [PermentCityId]" // +", [PermentPinCode]" // +", [Status]" // +", [Remark]" // + ") VALUES({0}, '{1}','{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}');" // , entity.StudentId, entity.CurrentAddress, entity.CurrentCountryId, entity.CurrentStateId, entity.CurrentDistrictId, entity.CurrentCityId, entity.CurrentPinCode // , entity.PermentAddress, entity.PermentCountryId, entity.PermentStateId, entity.PermentDistrictId, entity.PermentCityId, entity.PermentPinCode // ,entity.Status, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@CurrentAddress", entity.CurrentAddress); parameterlist.Add("@CurrentCountryId", entity.CurrentCountryId); parameterlist.Add("@CurrentStateId", entity.CurrentStateId); parameterlist.Add("@CurrentDistrictId", entity.CurrentDistrictId); parameterlist.Add("@CurrentCityId", entity.CurrentCityId); parameterlist.Add("@CurrentPinCode", entity.CurrentPinCode); parameterlist.Add("@PermentAddress", entity.PermentAddress); parameterlist.Add("@PermentCountryId", entity.PermentCountryId); parameterlist.Add("@PermentStateId", entity.PermentStateId); parameterlist.Add("@PermentDistrictId", entity.PermentDistrictId); parameterlist.Add("@PermentCityId", entity.PermentCityId); parameterlist.Add("@PermentPinCode", entity.PermentPinCode); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAddressDetailsInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(StudentAddress entity) { try { //string queryString = string.Format(" UPDATE [StudentAddressDetails] " + // " SET [CurrentAddress] ='{0}'" // +", [CurrentCountryId]='{1}'" // +", [CurrentStateId]='{2}'" // +", [CurrentDistrictId]='{3}'" // +", [CurrentCityId]='{4}'" // +", [CurrentPinCode]='{5}'" // +", [PermentAddress]='{6}'" // +", [PermentCountryId]='{7}'" // +", [PermentStateId]='{8}'" // +", [PermentDistrictId]='{9}'" // +", [PermentCityId]='{10}'" // +", [PermentPinCode]='{11}'" // + ",[Status] = '{12}'" // + ",[Remark] = '{13}'" // + " WHERE StudentId = {14};" // , entity.CurrentAddress, entity.CurrentCountryId, entity.CurrentStateId, entity.CurrentDistrictId, entity.CurrentCityId, entity.CurrentPinCode // , entity.PermentAddress, entity.PermentCountryId, entity.PermentStateId, entity.PermentDistrictId, entity.PermentCityId, entity.PermentPinCode // , entity.Status, entity.Remark, entity.StudentId); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@CurrentAddress", entity.CurrentAddress); parameterlist.Add("@CurrentCountryId", entity.CurrentCountryId); parameterlist.Add("@CurrentStateId", entity.CurrentStateId); parameterlist.Add("@CurrentDistrictId", entity.CurrentDistrictId); parameterlist.Add("@CurrentCityId", entity.CurrentCityId); parameterlist.Add("@CurrentPinCode", entity.CurrentPinCode); parameterlist.Add("@PermentAddress", entity.PermentAddress); parameterlist.Add("@PermentCountryId", entity.PermentCountryId); parameterlist.Add("@PermentStateId", entity.PermentStateId); parameterlist.Add("@PermentDistrictId", entity.PermentDistrictId); parameterlist.Add("@PermentCityId", entity.PermentCityId); parameterlist.Add("@PermentPinCode", entity.PermentPinCode); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentAddressDetailsUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Add(Religion entity) { try { //string queryString = string.Format(" INSERT INTO [ReligionDetails] ([AcademicYearId],[Religion],[Status],[Remark]) VALUES({0}, '{1}','{2}','{3}');", entity.AcademicYearId, entity.ReligionName, entity.Status, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@Religion", entity.ReligionName); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_ReligionDetailsInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(StudentLedger entity) { try { // string queryString = string.Format(" UPDATE [StudentLedger] " + //" SET [AcademicYearId] = {0}" + //",[StudentId] ={1}" + ",[TransactionDate] ='{2}'" + ",[FeeHeadId] ={3}" + ",[Cr] ={4}" + ",[Dr] ={5}" + ",[HeadBalance] ={6}" + ",[Balance]={7}" + //",[Status]={8}" + ",[Remark]='{9}'" + ",[CreatedBy]='{10}'" + ",[CreatedDate]='{11}'" + ",[ModifiedBy]='{12}'" + ",[ModifiedDate]='{13}'" + //",[ReceiptNo] ='{14}',[BankName] ='{15},[ChequeNumber] ='{16}" + //" WHERE StudentLedgerId = {17};", entity.AcademicYearId, //entity.StudentId, entity.TransactionDate, entity.FeeHeadId, entity.Cr, entity.Dr, entity.HeadBalance, entity.Balance, //entity.Status == true ? 1 : 0, entity.Remark, entity.CreatedBy, entity.CreatedDate, entity.ModifiedBy, entity.ModifiedDate, //entity.ReceiptNo, entity.BankName, entity.ChequeNumber, entity.StudentLedgerId); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@TransactionDate", entity.TransactionDate); parameterlist.Add("@FeeHeadId", entity.FeeHeadId); parameterlist.Add("@Cr", entity.Cr); parameterlist.Add("@Dr", entity.Dr); parameterlist.Add("@HeadBalance", entity.HeadBalance); parameterlist.Add("@Balance", entity.Balance); parameterlist.Add("@ReceiptNo", entity.ReceiptNo); parameterlist.Add("@BankName", entity.BankName); parameterlist.Add("@ChequeNumber", entity.ChequeNumber); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@CreatedBy", entity.CreatedBy); parameterlist.Add("@CreatedDate", entity.CreatedDate); parameterlist.Add("@ModifiedBy", entity.ModifiedBy); parameterlist.Add("@ModifiedDate", entity.ModifiedDate); parameterlist.Add("@StudentLedgerId", entity.StudentLedgerId); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentLedgerUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Add(AcademicYear entity) { try { //string queryString = string.Format(" INSERT INTO [AcademicYearDetails] ([AcademicYear],[StartDate],[EndDate],[Status],[Remark]) VALUES('{0}', '{1}','{2}', '{3}','{4}');", entity.AcademicYearName, entity.StartDate, entity.EndDate, entity.Status, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@AcademicYear", entity.AcademicYearName); parameterlist.Add("@StartDate", entity.StartDate); parameterlist.Add("@EndDate", entity.EndDate); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_AcademicYearInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Add(City entity) { try { //string queryString = string.Format(" INSERT INTO [CityDetails]([DistrictId],[City],[Status],[Remark]) VALUES({0}, '{1}','{2}', '{3}');", entity.DistrictId, entity.CityName, entity.Status, entity.Remark); //string s; //s = queryString; //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@DistrictId", entity.DistrictId); parameterlist.Add("@City", entity.CityName); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_CityDetailsInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Add(FeeClassDivision entity) { try { //string queryString = string.Format(" INSERT INTO [FeeClassDivisionDetails]([AcademicYearId],[FeeHeadId],[ClassDivisionId],[PeriodInMonthly],[AmountInMonthly],[AmountInYearly],[Status],[Remark]) VALUES({0}, {1},{2}, {3},{4},{5},{6},'{7}');", entity.AcademicYearId, entity.FeeHeadId, entity.ClassDivisionId, entity.PeriodInMonthly, entity.AmountInMonthly, entity.AmountInYearly, entity.Status == true ? 1 : 0, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@FeeHeadId", entity.FeeHeadId); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@PeriodInMonthly", entity.PeriodInMonthly); parameterlist.Add("@AmountInMonthly", entity.AmountInMonthly); parameterlist.Add("@AmountInYearly", entity.AmountInYearly); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_FeeClassDivisionInsert", parameterlist); } catch (Exception ex) { throw; } }
public void Edit(Asset entity) { try { // string queryString = string.Format(" UPDATE [AssetDetails] " + //" SET [SrNo] = {0}" + //",[Asset] = '{1}'" + // ",[TypeofAsset] = '{2}'" + // ",[Measure] = '{3}'" + // ",[Credit] = '{4}'" + // ",[Debit]='{5}'"+ // ",[Total]='{6}'" + // ",[Status]='{7}'" + // ",[Remark]='{8}'" + //" WHERE SrNo = {9};", entity.SrNo, entity.AssetName, entity.TypeofAsset, entity.Measure, entity.Credit, entity.Debit, entity.Total, entity.Status, entity.Remark, entity.SrNo); // int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@SrNo", entity.SrNo); parameterlist.Add("@TypeofAsset", entity.TypeofAsset); parameterlist.Add("@AssetName", entity.AssetName); parameterlist.Add("@Quantity", entity.Quantity); parameterlist.Add("@PricePerItem", entity.PricePerItem); parameterlist.Add("@Total", entity.Quantity * entity.PricePerItem); //entity.Total); parameterlist.Add("@PurchaseDate", entity.PurchaseDate); parameterlist.Add("@Condition", entity.Condition); parameterlist.Add("@AssesmentYear", entity.AssesmentYear); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_AssetDetailsUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Add(StudentTransaction entity, int schoolId) { String SqlQuery = "select max(StudentTransactionId) As ReceiptNo from StudentTransaction"; if (schoolId != 0) { SqlQuery = SqlQuery + " where SchoolId=" + schoolId + ";"; } DataTable dataTable = CommanMethodsForSQL.GetDataTable(SqlQuery); if (dataTable != null && dataTable.Rows.Count > 0) { foreach (DataRow dr in dataTable.Rows) { if (dr != null) { if (dr["ReceiptNo"] != DBNull.Value) { entity.ReceiptNo = Convert.ToInt32(dr["ReceiptNo"]) + 1; } else { entity.ReceiptNo = 1; } } else { entity.ReceiptNo = 1; } } } try { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@SchoolId", schoolId); parameterlist.Add("@TransactionDate", entity.TransactionDate); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@ReceiptNo", entity.ReceiptNo); parameterlist.Add("@BankName", entity.BankName); parameterlist.Add("@ChequeNumber", entity.ChequeNumber); parameterlist.Add("@ReceiptTotal", entity.ReceiptTotal); parameterlist.Add("@UserId", 0); parameterlist.Add("@OUT_StudentTransactionId", null); Hashtable outparameterlist = new Hashtable(); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentTransactionInsert", parameterlist, ref outparameterlist); int studentTransactionId = 0; if (outparameterlist != null && outparameterlist.Count > 0) { foreach (string parametername in outparameterlist.Keys) { if (parametername.StartsWith("@OUT_")) { studentTransactionId = Convert.ToInt32(outparameterlist[parametername]); } } } if (studentTransactionId > 0 && entity.StudentTransactionSubList != null && entity.StudentTransactionSubList.Count > 0) { foreach (Entities.StudentTransactionSub studentTransactionSub in entity.StudentTransactionSubList) { parameterlist = new Hashtable(); parameterlist.Add("@StudentTransactionId", studentTransactionId); parameterlist.Add("@FeeHead", studentTransactionSub.FeeHeadId); parameterlist.Add("@Cr", studentTransactionSub.Cr); parameterlist.Add("@DR", studentTransactionSub.Dr); parameterlist.Add("@Balance", studentTransactionSub.Balance); parameterlist.Add("@Remark", studentTransactionSub.Remark); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@TransactionDate", entity.TransactionDate); parameterlist.Add("@ReceiptNo", entity.ReceiptNo); parameterlist.Add("@BankName", entity.BankName); parameterlist.Add("@ChequeNumber", entity.ChequeNumber); parameterlist.Add("@UserId", 0); parameterlist.Add("@OUT_StudentTransactionSubId", null); outparameterlist = new Hashtable(); effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentTransactionSubInsert", parameterlist, ref outparameterlist); } } //string queryString = string.Format(" INSERT INTO [StudentTransaction]([AcademicYearId],[ClassDivisionId],[StudentId],[TransactionDate],[Status],[Remark]) VALUES({0}, {1},{2}, '{3}', {4}, '{5}');", // entity.AcademicYearId, entity.ClassDivisionId, entity.StudentId,entity.TransactionDate, entity.Status, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); } catch (Exception ex) { throw; } }
public void Edit(Student entity) { try { //string queryString = string.Format(" UPDATE [StudentDetails] " // + " SET " // + " [AcademicYearId] = '{0}'" // + ", [RegisterId] = '{1}'" // + ", [ClassDivisionId] = '{2}'" // + ", [Title] = '{3}'" // + ", [FirstName] = '{4}'" // + ", [MiddleName] = '{5}'" // + ", [LastName] = '{6}'" // + ", [MotherName] = '{7}'" // + ", [Gender] = '{8}'" // + ", [Nationality] = '{9}'" // + ", [ReligionCastId] = '{10}'" // + ", [DateOfBirth] = '{11}'" // + ", [PlaceOfBirth] = '{12}'" // + ", [DateOfAdmission] = '{13}'" // + ", [LastSchoolAttended] = '{14}'" // + ", [Progress] = '{15}'" // + ", [Conduct] = '{16}'" // + ", [DateOfLeavingSchool] = '{17}'" // + ", [ClassInWhichStudingAndSinceWhen] = '{18}'" // + ", [ReasonForLeavingSchool] = '{19}'" // + ", [RemarkOnTC] = '{20}'" // + ", [Status] = '{21}'" // + ", [Remark] = '{22}'" // + ", [AdharcardNo] = '{23}'" // + " WHERE StudentId = {24};", // entity.AcademicYearId, entity.RegisterId, entity.ClassDivisionId, // string.IsNullOrEmpty(entity.Title) ? entity.Title : entity.Title.Trim(), // entity.FirstName.Trim(), // string.IsNullOrEmpty(entity.MiddleName) ? entity.MiddleName : entity.MiddleName.Trim(), // entity.LastName.Trim(), // string.IsNullOrEmpty(entity.MotherName)? entity.MotherName: entity.MotherName.Trim(), // entity.Gender, entity.Nationality, entity.ReligionCastId, entity.DateOfBirth, entity.PlaceOfBirth.Trim(), entity.DateOfAdmission, // string.IsNullOrEmpty(entity.LastSchoolAttended) ? entity.LastSchoolAttended : entity.LastSchoolAttended.Trim(), // string.IsNullOrEmpty(entity.Progress) ? entity.Progress : entity.Progress.Trim(), // string.IsNullOrEmpty(entity.Conduct) ? entity.Conduct : entity.Conduct.Trim(), // entity.DateOfLeavingSchool, // string.IsNullOrEmpty(entity.ClassInWhichStudingAndSinceWhen) ? entity.ClassInWhichStudingAndSinceWhen : entity.ClassInWhichStudingAndSinceWhen.Trim(), // string.IsNullOrEmpty(entity.ReasonForLeavingSchool) ? entity.ReasonForLeavingSchool : entity.ReasonForLeavingSchool.Trim(), // string.IsNullOrEmpty(entity.RemarkOnTC) ? entity.RemarkOnTC : entity.RemarkOnTC.Trim(), // entity.Status, // string.IsNullOrEmpty(entity.Remark) ? entity.Remark : entity.Remark.Trim(), // string.IsNullOrEmpty(entity.AdharcardNo) ? entity.AdharcardNo : entity.AdharcardNo.Trim(), // entity.StudentId); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@SrNo", entity.SrNo); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@RegisterId", entity.RegisterId); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@Title", entity.Title); parameterlist.Add("@FirstName", entity.FirstName); parameterlist.Add("@MiddleName", entity.MiddleName); parameterlist.Add("@LastName", entity.LastName); parameterlist.Add("@MotherName", entity.MotherName); parameterlist.Add("@Gender", entity.Gender); parameterlist.Add("@Nationality", entity.Nationality); parameterlist.Add("@ReligionCastId", entity.ReligionCastId); parameterlist.Add("@DateOfBirth", entity.DateOfBirth); parameterlist.Add("@PlaceOfBirth", entity.PlaceOfBirth); parameterlist.Add("@AdharcardNo", entity.AdharcardNo); parameterlist.Add("@DateOfAdmission", entity.DateOfAdmission); parameterlist.Add("@MotherTounge", entity.MotherTounge); parameterlist.Add("@UStudentId", entity.UStudentId); parameterlist.Add("@LastSchoolAttended", entity.LastSchoolAttended); parameterlist.Add("@Progress", entity.Progress); parameterlist.Add("@Conduct", entity.Conduct); parameterlist.Add("@DateOfLeavingSchool", entity.DateOfLeavingSchool); parameterlist.Add("@LastSchoolClass", entity.LastSchoolClass); parameterlist.Add("@LastSchoolTCNo", entity.LastSchoolTCNo); parameterlist.Add("@ClassInWhichStudingAndSinceWhen", entity.ClassInWhichStudingAndSinceWhen); parameterlist.Add("@ReasonForLeavingSchool", entity.ReasonForLeavingSchool); parameterlist.Add("@RemarkOnTC", entity.RemarkOnTC); parameterlist.Add("@Status", entity.Status == true ? 1 : 0); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@PrevSchoolDateofLiving", entity.PrevSchoolDateofLiving); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentUpdate", parameterlist); } catch (Exception ex) { throw; } }
public void Add(Student entity) { try { Hashtable parameterlist = new Hashtable(); parameterlist.Add("@RegisterId", entity.RegisterId); parameterlist.Add("@ClassDivisionId", entity.ClassDivisionId); parameterlist.Add("@Title", entity.Title.Trim()); parameterlist.Add("@FirstName", entity.FirstName.Trim()); parameterlist.Add("@MiddleName", entity.MiddleName.Trim()); parameterlist.Add("@LastName", entity.LastName.Trim()); parameterlist.Add("@MotherName", entity.MotherName.Trim()); parameterlist.Add("@Gender", entity.Gender); parameterlist.Add("@Nationality", entity.Nationality); parameterlist.Add("@ReligionCastId", entity.ReligionCastId); parameterlist.Add("@DateOfBirth", entity.DateOfBirth); parameterlist.Add("@PlaceOfBirth", entity.PlaceOfBirth); parameterlist.Add("@AdharcardNo", entity.AdharcardNo.Trim()); parameterlist.Add("@DateOfAdmission", entity.DateOfAdmission); parameterlist.Add("@MotherTounge", entity.MotherTounge); parameterlist.Add("@UStudentId", entity.UStudentId); parameterlist.Add("@LastSchoolAttended", entity.LastSchoolAttended.Trim()); parameterlist.Add("@Progress", entity.Progress.Trim()); parameterlist.Add("@Conduct", entity.Conduct.Trim()); parameterlist.Add("@DateOfLeavingSchool", entity.DateOfLeavingSchool); parameterlist.Add("@LastSchoolClass", entity.LastSchoolClass); parameterlist.Add("@LastSchoolTCNo", entity.LastSchoolTCNo); parameterlist.Add("@ClassInWhichStudingAndSinceWhen", entity.ClassInWhichStudingAndSinceWhen.Trim()); parameterlist.Add("@ReasonForLeavingSchool", entity.ReasonForLeavingSchool.Trim()); parameterlist.Add("@RemarkOnTC", entity.RemarkOnTC.Trim()); parameterlist.Add("@Status", entity.Status == true ? 1 :0); parameterlist.Add("@Remark", entity.Remark.Trim()); parameterlist.Add("@PrevSchoolDateofLiving", entity.PrevSchoolDateofLiving); parameterlist.Add("@OUT_StudentId", null); Hashtable outparameterlist = new Hashtable(); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentInsert", parameterlist, ref outparameterlist); int studentTransactionId = 0; if (outparameterlist != null && outparameterlist.Count > 0) { foreach (string parametername in outparameterlist.Keys) { if (parametername.StartsWith("@OUT_")) { studentTransactionId = Convert.ToInt32(outparameterlist[parametername]); } } } //string queryString = string.Format(" INSERT INTO [StudentDetails](" // + " [AcademicYearId]" // + ",[RegisterId]" // + ",[ClassDivisionId]" // + ",[Title]" // + ",[FirstName]" // + ",[MiddleName]" // + ",[LastName]" // + ",[MotherName]" // + ",[Gender]" // + ",[Nationality]" // + ",[ReligionCastId]" // + ",[DateOfBirth]" // + ",[PlaceOfBirth]" // + ",[DateOfAdmission]" // + ",[LastSchoolAttended]" // + ",[Progress]" // + ",[Conduct]" // + ",[DateOfLeavingSchool]" // + ",[ClassInWhichStudingAndSinceWhen]" // + ",[ReasonForLeavingSchool]" // + ",[RemarkOnTC]" // + ",[Status]" // + ",[Remark]" // + ") VALUES({0}, {1},{2}, '{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}','{16}','{17}','{18}','{19}','{20}',{21},'{22}');", // entity.AcademicYearId, entity.RegisterId, entity.ClassDivisionId, entity.Title, entity.FirstName, entity.MiddleName, entity.LastName, entity.MotherName, // entity.Gender, entity.Nationality, entity.ReligionCastId, entity.DateOfBirth, entity.PlaceOfBirth, entity.DateOfAdmission, entity.LastSchoolAttended, // entity.Progress, entity.Conduct, entity.DateOfLeavingSchool, entity.ClassInWhichStudingAndSinceWhen, entity.ReasonForLeavingSchool, entity.RemarkOnTC, // entity.Status == true ? 1 : 0, entity.Remark); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); } catch (Exception ex) { throw; } }
public void Add(StudentParent entity) { try { //string queryString = string.Format(" INSERT INTO [StudentParentDetails](" // + " [StudentId]" // + ", [Title]" // + ", [FirstName]" // + ", [MiddleName]" // + ", [LastName]" // + ", [Gender]" // + ", [Address]" // + ", [CountryId]" // + ", [StateId]" // + ", [DistrictId]" // + ", [CityId]" // + ", [PinCode]" // + ", [MobileNumber]" // + ", [ContactNo]" // + ", [Occupation]" // + ", [CompanyName]" // + ", [CompanyAddress]" // + ", [CompanyContactNo]" // + ", [Status]" // + ", [Remark]" // + ", [BankName]" // + ", [AccountNo]" // + ", [Branch]" // + ", [IFSCCode]" // + ") VALUES({0}, '{1}','{2}', '{3}', '{4}', '{5}', '{6}', '{7}', '{8}', '{9}', '{10}', '{11}', '{12}', '{13}', '{14}', '{15}', '{16}', '{17}', '{18}', '{19}', '{20}', '{21}', '{22}', '{23}');" // , entity.StudentId, entity.Title, entity.FirstName, entity.MiddleName, entity.LastName, entity.Gender, entity.Address, entity.CountryId // , entity.StateId, entity.DistrictId, entity.CityId, entity.PinCode, entity.MobileNumber, entity.ContactNo, entity.Occupation, entity.CompanyName // ,entity.CompanyAddress, entity.CompanyContactNo, entity.Status == true ? 1 : 0, entity.Remark, entity.BankName, entity.AccountNo, entity.Branch, entity.IFSCCode); //int effetedRows = CommanMethodsForSQL.ExecuteNonQuery(queryString); Hashtable parameterlist = new Hashtable(); parameterlist.Add("@StudentId", entity.StudentId); parameterlist.Add("@Title", entity.Title); parameterlist.Add("@FirstName", entity.FirstName); parameterlist.Add("@MiddleName", entity.MiddleName); parameterlist.Add("@LastName", entity.LastName); parameterlist.Add("@Gender", entity.Gender); parameterlist.Add("@Address", entity.Address); parameterlist.Add("@CountryId", entity.CountryId); parameterlist.Add("@StateId", entity.StateId); parameterlist.Add("@DistrictId", entity.DistrictId); parameterlist.Add("@CityId", entity.CityId); parameterlist.Add("@PinCode", entity.PinCode); parameterlist.Add("@MobileNumber", entity.MobileNumber); parameterlist.Add("@ContactNo", entity.ContactNo); parameterlist.Add("@Occupation", entity.Occupation); parameterlist.Add("@CompanyName", entity.CompanyName); parameterlist.Add("@CompanyAddress", entity.CompanyAddress); parameterlist.Add("@CompanyContactNo", entity.CompanyContactNo); parameterlist.Add("@Status", entity.Status); parameterlist.Add("@Remark", entity.Remark); parameterlist.Add("@BankName", entity.BankName); parameterlist.Add("@AccountNo", entity.AccountNo); parameterlist.Add("@Branch", entity.Branch); parameterlist.Add("@IFSCCode", entity.IFSCCode); int effetedRows = CommanMethodsForSQL.ExecuteNonQueryProcedure("sp_StudentParentDetailsInsert", parameterlist); } catch (Exception ex) { throw; } }