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