/// <summary>
/// Aim of method: The Method is used to update e-challan
/// Database Table :society_aims
/// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
/// </summary>
/// <returns></returns>
public ReturnClass.ReturnBool update_echallan_status(bl_RTI_Fees reg)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
try
{
using (TransactionScope ts = new TransactionScope())
{
MySqlParameter[] pr = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no)
};
string qrr = "UPDATE appli_parameter_complete_status SET complete_status='Y' where firm_RTI_provisional_no=@RTI_provisional_no and appli_parameter_code IN ('S12') ";
rb = db.executeUpdateQuery(qrr, pr);
if (rb.status == true)
{
ts.Complete();
rb.status = true;
}
}
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
/// <summary>
/// Aim of method: The Method is used to delete e-challan from e-challan
/// Database Table :society_aims
/// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
/// </summary>
/// <returns></returns>
public ReturnClass.ReturnBool delete_echallan(bl_RTI_Fees reg)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
try
{
using (TransactionScope ts = new TransactionScope())
{
MySqlParameter[] pr = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no),
new MySqlParameter("serial_no",reg.Serial_no)
};
MySqlParameter[] pr1 = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no),
new MySqlParameter("serial_no",reg.Serial_no)
};
string qr = "insert into echallan_detail_log select * from echallan_detail where RTI_provisional_no=@RTI_provisional_no and serial_no=@serial_no ";
rb = db.executeInsertQuery(qr, pr);
if (rb.status == true)
{
string qrr = "delete from echallan_detail where RTI_provisional_no=@RTI_provisional_no and serial_no=@serial_no";
rb = db.executeDeleteQuery(qrr, pr1);
}
if (rb.status == true)
{
ts.Complete();
rb.status = true;
}
}
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
//#region
///// <summary>
///// Aim of method: The Method is used to get fee from society_fees_master
///// Database Table :society_aims
///// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
///// </summary>
///// <returns></returns>
//public ReturnClass.ReturnDataTable getfee(bl_RTI_Fees reg)
//{
// ReturnClass.ReturnDataTable rb = new ReturnClass.ReturnDataTable();
// db_maria_connection db = new db_maria_connection();
// try
// {
// string qr = "select fees_code,fees_details,Amount from society_fees_master where society_type_code=(select society_type_code from society where RTI_provisional_no=@RTI_provisional_no) ";
// MySqlParameter[] pr = new MySqlParameter[]{
// new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no)
// };
// rb = db.executeSelectQuery(qr, pr);
// }
// catch (Exception Ex)
// {
// rb.status = false;
// rb.message = Ex.Message;
// }
// return rb;
//}
//#endregion
#region
/// <summary>
/// Aim of method: The Method is used to get record from e-challan
/// Database Table :society_aims
/// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
/// </summary>
/// <returns></returns>
public ReturnClass.ReturnDataTable getrecord(bl_RTI_Fees reg)
{
ReturnClass.ReturnDataTable rb = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
try
{
string qr = "select * from echallan_detail where RTI_provisional_no=@RTI_provisional_no order by serial_no";
MySqlParameter[] pr = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",reg.RTI_provisional_no)
};
rb = db.executeSelectQuery(qr, pr);
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
