/// <summary>
/// Aim of method: The Method is used to Insert into e-challan
/// Database Table :society_aims
/// bl layer use:bl_society_fee- (MEMORANDUM_OF_SOCIETY_From_1_Gridview3())
/// </summary>
/// <returns></returns>
public ReturnClass.ReturnBool insert_echallan_details(echallan ec)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
try
{
using (TransactionScope ts = new TransactionScope())
{
MySqlParameter[] pr1 = new MySqlParameter[]{
new MySqlParameter("RTI_provisional_no",ec.Society_provisional_no), // Need to change by Naveen
new MySqlParameter("serial_no",ec.Serial_no),
new MySqlParameter("tr_ref_no",ec.Tr_ref_no),
new MySqlParameter("amount",ec.Amount),
new MySqlParameter("tin_cin",ec.Tin_cin),
new MySqlParameter("tr_entry_date",ec.Tr_entry_date),
new MySqlParameter("date_ac",ec.Date_ac),
new MySqlParameter("major_head",ec.Major_head),
new MySqlParameter("sub_major_head",ec.Sub_major_head),
new MySqlParameter("minor_head", ec.Minor_head),
new MySqlParameter("sub_head",ec.Sub_head),
new MySqlParameter("purpose",ec.Purpose),
new MySqlParameter("Challan_Category",ec.Challan_Category),
new MySqlParameter("client_ip",ec.Client_ip),
new MySqlParameter("user_id",ec.User_id),
new MySqlParameter("fees_master_code",ec.Fees_master_code)
};
string qr = " INSERT INTO echallan_detail(RTI_provisional_no,serial_no,tr_ref_no,amount,tin_cin,tr_entry_date,date_ac,major_head,"
+ " sub_major_head,minor_head,sub_head,purpose,Challan_Category, client_ip, user_id,fees_master_code) values"
+ " (@RTI_provisional_no,@serial_no,@tr_ref_no,@amount,@tin_cin,@tr_entry_date,@date_ac,@major_head,@sub_major_head,"
+ " @minor_head,@sub_head,@purpose,@Challan_Category, @client_ip, @user_id,@fees_master_code)";
rb = db.executeInsertQuery(qr, pr1);
if (rb.status == true)
{
ts.Complete();
}
}
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
/// <summary>
/// Aim of method: The Method is used to select_tr_ref_no 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 select_tr_ref_no(echallan ec)
{
ReturnClass.ReturnDataTable rb = new ReturnClass.ReturnDataTable();
db_maria_connection db = new db_maria_connection();
try
{
string qr = "select tr_ref_no from echallan_detail where tr_ref_no=@tr_ref_no";
MySqlParameter[] pr = new MySqlParameter[]{
new MySqlParameter("tr_ref_no",ec.Tr_ref_no)
};
rb = db.executeSelectQuery(qr, pr);
}
catch (Exception Ex)
{
rb.status = false;
rb.message = Ex.Message;
}
return rb;
}
