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