public ReturnClass.ReturnBool update_password(bl_login bl)
{
using (TransactionScope ts = new TransactionScope())
{
string str = @"insert into login_log select * from login WHERE login.UserID =@regid1";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("regid1", bl.RegistrationID)
};
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
string str2 = @"update login set Password=@Password , Client_ip=@Client_ip, ClientOS=@ClientOS,
ClientBrowser=@ClientBrowser, user_agent=@user_agent , PasswordChange=@PAssworchng where UserID=@regid and Password=@pass";
MySqlParameter[] pm2 = new MySqlParameter[] {
new MySqlParameter("Password", bl.NewPass),
new MySqlParameter("PAssworchng", bl.PasswordChange),
new MySqlParameter("regid", bl.RegistrationID),
new MySqlParameter("Client_ip", bl.UserIP),
new MySqlParameter("ClientOS", bl.UserOS),
new MySqlParameter("ClientBrowser", bl.User_browser),
new MySqlParameter("user_agent", bl.UserAgent),
new MySqlParameter("pass", bl.Password)
};
rb = db.executeUpdateQuery(str2, pm2);
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
public ReturnClass.ReturnBool insert_office(bl_report bl)
{
string str = @"insert into office
(NewOfficeCode,DistrictCodeNew,officelevel,OfficeName,BaseDeptCode,countrycode,
Statecode,Officeaddress,contactno,email,fax,Officeurl,OfficeCategory)
values
(@NewOfficeCode,@DistrictCodeNew,@officelevel,@OfficeName,@BaseDeptCode,@countrycode,
@Statecode,@Officeaddress,@contactno,@email,@fax,@Officeurl,@OfficeCategory)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NewOfficeCode", bl.Officeid),
new MySqlParameter("DistrictCodeNew", bl.District),
new MySqlParameter("officelevel", bl.Office_level_id),
new MySqlParameter("OfficeName", bl.Office_id),
new MySqlParameter("BaseDeptCode", bl.Base_department),
new MySqlParameter("countrycode", bl.Country),
new MySqlParameter("Statecode", bl.State),
new MySqlParameter("Officeaddress", bl.Address),
new MySqlParameter("contactno", bl.Contact),
new MySqlParameter("email", bl.Email_id),
new MySqlParameter("fax", bl.Fax),
new MySqlParameter("Officeurl", bl.Url),
new MySqlParameter("OfficeCategory", bl.Category)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool Insert_empOfficeMap(bl_empMap ur)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
using (TransactionScope ts = new TransactionScope())
{
string strQuery = @"INSERT INTO emp_office_mapping
(office_mapping_id,emp_code,office_id,designation_id,base_department_id,office_level_id,district_id_ofc,office_category,user_id,charge_type,Active,client_ip, FromActive, ToActive,role_id)
VALUES(@office_mapping_id,@emp_code,@office_id,@designation_id,@base_department_id,@office_level_id,@district_id_ofc,@office_category,@user_id,@charge_type,@Active,@client_ip, @fromActive, @toActive,@role_id)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("office_mapping_id", ur.Office_mapping_id),
new MySqlParameter("emp_code", ur.Emp_code),
new MySqlParameter("office_id", ur.Office_id),
new MySqlParameter("designation_id", ur.Designation_id),
new MySqlParameter("base_department_id", ur.Base_department_id),
new MySqlParameter("office_level_id", ur.Office_level_id),
new MySqlParameter("district_id_ofc", ur.District_id_ofc),
new MySqlParameter("office_category", ur.Office_category),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("charge_type", ur.Charge_type),
new MySqlParameter("Active", ur.Active),
new MySqlParameter("client_ip", ur.Client_ip),
new MySqlParameter("fromActive", ur.FromActive),
new MySqlParameter("toActive", ur.ToActive),
new MySqlParameter("role_id", ur.Role_id)
};
rb = db.executeInsertQuery(strQuery, pm);
if (rb.status == true)
{
foreach (string str12 in ur.Permission)
{
ur.Approve = str12;
if (rb.status == true)
{
string quert = @"insert into permission (emp_map_id,ActionPermission,userid,ipaddress,useragent,useros,clientbrowser)
Values(@emp_map_id,@ActionPermission,@userid,@ipaddress,@useragent,@useros,@clientbrowser)";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("emp_map_id", ur.Office_mapping_id),
new MySqlParameter("ActionPermission", ur.Approve),
new MySqlParameter("userid", ur.User_id),
new MySqlParameter("ipaddress", ur.Client_ip),
new MySqlParameter("useragent", ur.Useragent),
new MySqlParameter("useros", ur.ClientOS),
new MySqlParameter("clientbrowser", ur.ClientBrowser)
};
rb = db.executeInsertQuery(quert, pm1);
}
}
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
//-------------------------pending for approval page---------------------------------------------------------------------//
public ReturnClass.ReturnBool delete_notice_and_file(Notice_Entry ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope transScope = new TransactionScope())
{
string query = "insert into notice_board_log select * from Notice_Board where Notice_Id=@NoticeID";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
};
rb = db.executeInsertQuery(query, pm);
if (rb.status == true)
{
string query2 = @"delete from Notice_Board where Notice_Id=@NoticeID ";
MySqlParameter[] pm2 = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
// new MySqlParameter("district_id",ne.district_id)
};
rb = db.executeDeleteQuery(query2, pm2);
}
if (ne.file_id == null)
{
}
else
{
if (rb.status == true)
{
string query3 = "insert into notice_file_details_log select * from notice_file_details where file_id=@file_id";
MySqlParameter[] pm3 = new MySqlParameter[] {
new MySqlParameter("file_id", ne.file_id)
};
rb = db.executeInsertQuery(query3, pm3);
}
if (rb.status == true)
{
string query4 = "delete from notice_file_details where file_id=@file_id";
MySqlParameter[] pm4 = new MySqlParameter[] {
new MySqlParameter("file_id", ne.file_id)
};
rb = db.executeInsertQuery(query4, pm4);
}
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
public ReturnBool update_pending_login_application(admin_ba_layer ur)
{
using (TransactionScope transScope = new TransactionScope())
{
query = @"update user_login set applicant_verified=@applicant_verified,client_ip=@client_ip,reason=@reason,extra_1=@extra_1 where applicant_mobile=@applicant_mobile and applicant_id=@applicant_id";
MySqlParameter[] pmm = new MySqlParameter[]
{
new MySqlParameter("applicant_verified", ur.Status),
new MySqlParameter("extra_1", ur.Status),
new MySqlParameter("applicant_verifiedd", "N"),
new MySqlParameter("applicant_mobile", ur.Applicant_mobile),
new MySqlParameter("applicant_id", ur.Applicant_id),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("reason", ur.Reason)
};
rb = db.executeUpdateQuery(query, pmm);
if (ur.Status == "Y")
{
if (rb.status == true)
{
ReturnDataTable dt = find_payment_informatyion_of_doctor(ur);
if (dt.table.Rows.Count > 0)
{
query = @"update payment_information_of_doctor set to_be_paid_by_user=@to_be_paid_by_user,client_ip=@client_ip where user_id=@applicant_mobile ";
MySqlParameter[] pmmm = new MySqlParameter[]
{
new MySqlParameter("to_be_paid_by_user", ur.Type),
new MySqlParameter("applicant_mobile", ur.Applicant_mobile),
new MySqlParameter("client_ip", ur.Client_id)
};
rb = db.executeUpdateQuery(query, pmmm);
}
else
{
query = @"insert into payment_information_of_doctor (user_id,to_be_paid_by_user,client_ip) values(@user_id,@to_be_paid_by_user,@client_ip) ";
MySqlParameter[] pmmm = new MySqlParameter[]
{
new MySqlParameter("to_be_paid_by_user", ur.Type),
new MySqlParameter("user_id", ur.Applicant_mobile),
new MySqlParameter("client_ip", ur.Client_id)
};
rb = db.executeInsertQuery(query, pmmm);
}
}
}
if (rb.status == true)
{
transScope.Complete();
}
}
return(rb);
}
} // End
//ReturnClass.ReturnDataTable GetRtiStatus_detail(bl_RTI_Request bl)
//{
// ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
// db_maria_connection db = new db_maria_connection();
// string str = "select rti_id, Isvalid from rti_status where rti_id = @rti_id";
// MySqlParameter[] pm = new MySqlParameter[]
// {
// new MySqlParameter("rti_id",bl.RTI_Request_id)
// };
// dt = db.executeSelectQuery(str, pm);
// return dt;
//}
////end of Get Rti Status ISvalid
public ReturnClass.ReturnBool update_Rti_status(bl_RTI_Request bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string str = "insert into rti_status_log select * from rti_status WHERE rti_status.rti_id = @regid1";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("regid1", bl.RTI_Request_id)
};
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
string str1 = "Update rti_status set Isvalid=@isvalid where rti_id = @rtiid ";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("isvalid", bl.IsValid),
new MySqlParameter("rtiid", bl.RTI_Request_id)
};
rb = db.executeUpdateQuery(str1, pm1);
if (rb.status == true)
{
ts.Complete();
}
}
}
return(rb);
}
public ReturnClass.ReturnBool Insert_empmap(bl_report bl)
{
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
string strQuery = @"INSERT INTO emp_office_mapping
(office_mapping_id,emp_code,office_id,designation_id,base_department_id,office_level_id,district_id_ofc,office_category,user_id,charge_type,Active,client_ip)
VALUES(@office_mapping_id,@emp_code,@office_id,@designation_id,@base_department_id,@office_level_id,@district_id_ofc,@office_category,@user_id,@charge_type,@Active,@client_ip)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("office_mapping_id", bl.Office_mapping_id),
new MySqlParameter("emp_code", bl.Emp_code),
new MySqlParameter("office_id", bl.Office_id),
new MySqlParameter("designation_id", bl.Designation_id),
new MySqlParameter("base_department_id", bl.Base_department_id),
new MySqlParameter("office_level_id", bl.Office_level_id),
new MySqlParameter("district_id_ofc", bl.District_id_ofc),
new MySqlParameter("office_category", bl.Office_category),
new MySqlParameter("user_id", bl.User_id),
new MySqlParameter("charge_type", bl.Charge_type),
new MySqlParameter("Active", bl.Active),
new MySqlParameter("client_ip", bl.Client_ip)
};
rb = db.executeInsertQuery(strQuery, pm);
return(rb);
}
} // end of get GetGender
public ReturnClass.ReturnBool Update_registration(bl_RTI_Registration bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string str1 = "insert into user_registration_log select * from user_registration WHERE user_registration.RegistrationID = @regid1";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("regid1",bl.RegistrationID)
};
string str = "update user_registration us set us.IsValid=@isvalid where us.RegistrationID = @regid";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("isvalid",bl.IsValid),
new MySqlParameter("regid",bl.RegistrationID)
};
rb = db.executeInsertQuery(str1, pm1);
if (rb.status == true)
{
rb = db.executeUpdateQuery(str, pm);
}
if (rb.status == true)
{
ts.Complete();
}
};
return rb;
}
public ReturnClass.ReturnBool Insert_Login(bl_RTI_Registration ur)
{
string strQuery = "INSERT INTO login " +
"(LoginID, UserID, Password, RollID, PasswordChange, DisableTime, Active,Client_ip,ClientOS,ClientBrowser,user_agent) " +
" VALUES (@loginID, @userID, @password, @rollID, @passwordChange, @disableTime, @active, @Client_ip, @ClientOS, @ClientBrowser, @user_agent)";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("loginID", ur.RegistrationID),
new MySqlParameter("userID", ur.UserID),
new MySqlParameter("password", ur.Password),
new MySqlParameter("rollID", ur.RollID),
new MySqlParameter("passwordChange", ur.PasswordChange ),
new MySqlParameter("disableTime", ur.DisableTime),
new MySqlParameter("active", ur.Active),
new MySqlParameter("Client_ip", ur.UserIP),
new MySqlParameter("ClientOS", ur.UserOS ),
new MySqlParameter("ClientBrowser", ur.User_browser),
new MySqlParameter("user_agent", ur.UserAgent)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return dt;
}
public ReturnClass.ReturnBool approve_notice(Notice_Entry ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string qr1 = @"insert into notice_board_log select * from Notice_Board where Notice_Id=@NoticeID";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID)
};
rb = db.executeInsertQuery(qr1, pm);
if (rb.status == true)
{
string qr = " UPDATE Notice_Board SET status=@status where Notice_Id=@NoticeID ";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("NoticeID", ne.NoticeID),
new MySqlParameter("status", ne.status)
// new MySqlParameter("district_id",ne.district_id)
};
rb = db.executeUpdateQuery(qr, pm1);
ts.Complete();
}
}
return(rb);
}
}//end
public ReturnClass.ReturnBool Insert_rti_status(bl_RTI_Request ur)
{
string strQuery = "INSERT INTO rti_status " +
"( rti_id, user_id, status, action_id, officer_maping_id, IPAddress, action_date, IsValid, IsNew , client_OS, useragent , client_browser)" +
" VALUES ( @rti_ID, @user_id, @status, @action_id, @officer_maping_id, @IPAddress, @action_date, @isValid, @isnew, @client_OS , @useragent, @client_browser )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_ID", ur.RTI_filed_user_id),
new MySqlParameter("user_id", ur.RTI_login_userName),
new MySqlParameter("status", ur.Rti_Status),
new MySqlParameter("action_id", ur.Action_id),
new MySqlParameter("officer_maping_id", ur.Office_mapping_id),
new MySqlParameter("IPAddress", ur.RTI_ipaddress),
new MySqlParameter("action_date", ur.Action_date),
new MySqlParameter("isValid", ur.IsValid),
new MySqlParameter("isnew", ur.IsNew),
new MySqlParameter("client_OS", ur.Client_os),
new MySqlParameter("useragent", ur.UserAgent),
new MySqlParameter("client_browser", ur.ClientBrowser)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return(dt);
}//end of Insert_rti_filed_user
public ReturnClass.ReturnBool update_file_details(Upload_doc ud)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
//BA_layer ba = new BA_layer();
MySqlParameter[] param = new MySqlParameter[] {
new MySqlParameter("f_id", ud.file_ID),
//new MySqlParameter("file_id",ud.file_id),
new MySqlParameter("Header", ud.Filename),
new MySqlParameter("mime_type", ud.File_Extn),
new MySqlParameter("file_data", ud.File_Data),
new MySqlParameter("Client_Ip", ud.Client_ip),
new MySqlParameter("User_Id", ud.User_id),
new MySqlParameter("Date_Time", ud.Upload_Date)
};
try
{
using (TransactionScope ts = new TransactionScope())
{
string qur = "insert into notice_file_details_log select * from notice_file_details where file_id=@f_id";
rb = db.executeInsertQuery(qur, param);
if (rb.status == true)
{
if (ud.Status != "Y")
{
string delQUr = "delete from notice_file_details where file_id=@f_id";
rb = db.executeDeleteQuery(delQUr, param);
}
else if (ud.Status == "Y")
{
string upqur = "update notice_file_details set File_Header=@Header,mime_type=@mime_type,file_data=@file_data,"
+ "client_ip=@Client_Ip,user_code=@User_Id,upload_date=@Date_Time "
+ "where file_id=@f_id";
rb = db.executeUpdateQuery(upqur, param);
}
}
if (rb.status == true)
{
ts.Complete();
}
}
}
catch (Exception ex)
{
rb.status = false;
Gen_Error_Rpt.Write_Error("Notice Edit Form - Update Method() :- " + ex.Message.ToString());
}
return(rb);
}
public ReturnClass.ReturnBool insert_action_file(bl_RTIDataForApplicant bl1)
{
string str = @"insert into action_files
( action_fileID, fileName, fileType, fileData, FileDescription, action_id, emp_mapping_id, rti_id )
values
( @action_file_id, @file_name, @file_type, @file_data, @file_description, @action_id, @emp_map_id, @rti_id)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("action_file_id", bl1.RTI_fileID),
new MySqlParameter("file_name", bl1.RTI_fileName),
new MySqlParameter("file_type", bl1.RTI_fileType),
new MySqlParameter("file_data", bl1.RTI_fileData),
new MySqlParameter("file_description", bl1.FileDescription),
new MySqlParameter("action_id", bl1.Action_id),
new MySqlParameter("emp_map_id", bl1.Office_mapping_id),
new MySqlParameter("rti_id", bl1.Rti_id)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool Upload_Video(upload_doc fu)
{
//query = "INSERT INTO online_videos (Name,Data,contentType,path)VALUES(@Name,@Data,@contentType,@path)";
query = "INSERT INTO online_videos (Name,contentType,path,extension)VALUES(@Name,@contentType,@path,@extension)";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("Name", fu.Document_name),
// new MySqlParameter("Data", fu.Document_data),
new MySqlParameter("contentType", fu.Mime_type),
new MySqlParameter("path", fu.Panjiyan_category_id),
new MySqlParameter("extension", fu.File_extn)
};
rc = da.executeInsertQuery(query, pm1);
return(rc);
}
/// <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;
}
public ReturnClass.ReturnBool insert_feedback(bl_feedback bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
string str = "insert Into feedback(user_id,feedback,subject,specify) VALUES (@userid,@feedback,@subject,@specify)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("userid", bl.Userid),
new MySqlParameter("feedback", bl.Feedback),
new MySqlParameter("subject", bl.Subject),
new MySqlParameter("specify", bl.Specify)
};
rb = db.executeInsertQuery(str, pm);
return(rb);
}
public ReturnClass.ReturnBool insertAction(bl_Action bl)
{
string str = "insert into ddl_list(DDL_List_ID,DDL_Name_Value,DisplayName_en,Remarks,DisplayOrder,Category) values(@Ddl_id,@DDL_Name_Value,@ActionName,@Remarks,@DisplayOrder,@Category)";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("Ddl_id",bl.Ddl_id),
new MySqlParameter("DDL_Name_Value",bl.DDL_Name_Value),
new MySqlParameter("ActionName",bl.Actionname),
new MySqlParameter("Remarks",bl.Remark),
new MySqlParameter("DisplayOrder",bl.DisplayOrder),
new MySqlParameter("Category",bl.Category)
};
rb = db.executeInsertQuery(str, pm);
return rb;
}
public ReturnClass.ReturnBool InsertOtp(bl_RTI_Registration bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
string str = "insert into otp_mobile (user_id,mobile_no,type,client_ip,sms_detail,application_id) values(@user_id,@mobile_no,@type,@client_ip,@sms_detail,@application_id)";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("user_id",bl.UserID),
new MySqlParameter("mobile_no",bl.MobileNo),
new MySqlParameter("type",bl.Type),
new MySqlParameter("client_ip",bl.UserIP),
new MySqlParameter("sms_detail",bl.Sms_detail),
new MySqlParameter("application_id",bl.RegistrationID),
};
rb = db.executeInsertQuery(str, pm);
return rb;
}
public ReturnClass.ReturnBool Insert_RTI_detail(bl_RTI_Request ur)
{
string strQuery = "INSERT INTO rti_detail " +
"( rti_id, applicant_type, Applicant_Name_en, Gender, Email_ID, Address, Country_Code, Country_Name," +
" State_Code, District_Code, Pin_Code, Mobile_No, Is_BPL, BPL_Card_No, BPL_Year_Issue, BPL_Issuing_Authority, " +
" rti_Subject, rti_Details, User_ID, Client_IP,securitycode , IsRTIFileUpload, Client_OS, ClientBrowser, UserAgent ) " +
" VALUES (@rti_id, @applicant_type, @Applicant_Name_en, @Gender, @Email_ID, @Address, @Country_Code, @country_Name, @State_Code, " +
" @District_Code, @Pin_Code, @Mobile_No, @Is_BPL, @BPL_Card_No, @BPL_Year_Issue, @BPL_Issuing_Authority, " +
" @rti_Subject, @rti_Details, @User_ID, @Client_IP, @securitycode, @is_RTI_FILE_Upload, @ClientOS, @clientBrowser, @userAgent )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_id", ur.RTI_Request_id),
new MySqlParameter("applicant_type", ur.UserType),
new MySqlParameter("Applicant_Name_en", ur.NameEnglish),
new MySqlParameter("Gender", ur.Gender),
new MySqlParameter("Email_ID", ur.Email),
new MySqlParameter("Address", ur.Address),
new MySqlParameter("Country_Code", ur.Country),
new MySqlParameter("State_Code", ur.State),
new MySqlParameter("District_Code", ur.District),
new MySqlParameter("Pin_Code", ur.Pincode),
new MySqlParameter("Mobile_No", ur.Mobile),
new MySqlParameter("Is_BPL", ur.RTI_Is_bpl),
new MySqlParameter("BPL_Card_No", ur.BPL_Card_No),
new MySqlParameter("BPL_Year_Issue", ur.BPL_Issue_Year),
new MySqlParameter("BPL_Issuing_Authority", ur.BPL_Issuing_Authority),
new MySqlParameter("rti_Subject", ur.Rti_Subject),
new MySqlParameter("rti_Details", ur.RTI_Text),
new MySqlParameter("User_ID", ur.RTI_login_userName),
new MySqlParameter("country_Name", ur.CountryName),
new MySqlParameter("Client_IP", ur.RTI_ipaddress),
new MySqlParameter("securitycode", ur.Securitycode),
new MySqlParameter("is_RTI_FILE_Upload", ur.IsRTIFileUpload),
new MySqlParameter("userAgent", ur.UserAgent),
new MySqlParameter("ClientOS", ur.Client_os),
new MySqlParameter("clientBrowser", ur.ClientBrowser)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return(dt);
}//end
//------------------------- district dmf home page-------24 april-2017----------------------------------------------------//
// public ReturnClass.ReturnDataTable Call_index(bl_home ur)
// {
// db_maria_connection db = new db_maria_connection();
// ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
// MySqlParameter[] pm = new MySqlParameter[]
// {
// new MySqlParameter("District_id",ur.District_id)
// };
//// string qr = @"select notice_id,file_id,Header,Hyperlink,File_Type,active,status,bold,blink,priority,image,permanent,NOW(),
////
////(CASE WHEN Validity_From IS NOT NULL OR Validity_From !='' THEN DATE_FORMAT(Validity_From,'%d/%m/%Y') ELSE 'Not Available' END)Validity_From,
////(CASE WHEN Validity_To IS NOT NULL OR Validity_To!='' THEN DATE_FORMAT(Validity_To,'%d/%m/%Y') ELSE 'Not Available' END)Validity_To,
////(CASE WHEN DATE_FORMAT(Publish_Date,'%d/%m/%Y') IS NULL OR DATE_FORMAT(Publish_Date,'%d/%m/%Y')='' THEN DATE_FORMAT(validity_from,'%d/%m/%Y') ELSE DATE_FORMAT(Publish_Date,'%d/%m/%Y') END)Publish_Date,
////(case when Permanent='Y' then 'Yes' when Permanent='N' then 'No' end)permanent,
//// (case when color is null or color='' then '#000000' else color end)color,
//// (case when url is null or url='' then '../user/notice_download.aspx' else url end)url
////
//// from notice_board where active='A' and status='A' and district_id=@District_id
//// and case when
//// permanent = 'N' then NOW() between validity_from AND Validity_To else NOW() >= Publish_Date end";
// string qr = @"select nb.notice_id,nb.file_id,nb.Header,nb.Hyperlink,nb.File_Type,nb.active,nb.status,nb.bold,nb.blink,nb.priority,nb.image,nb.permanent,NOW(),
//
//(CASE WHEN Validity_From IS NOT NULL OR Validity_From !='' THEN DATE_FORMAT(Validity_From,'%d/%m/%Y') ELSE 'Not Available' END)Validity_From,
//(CASE WHEN Validity_To IS NOT NULL OR Validity_To!='' THEN DATE_FORMAT(Validity_To,'%d/%m/%Y') ELSE 'Not Available' END)Validity_To,
//(CASE WHEN DATE_FORMAT(Publish_Date,'%d/%m/%Y') IS NULL OR DATE_FORMAT(Publish_Date,'%d/%m/%Y')='' THEN DATE_FORMAT(validity_from,'%d/%m/%Y') ELSE DATE_FORMAT(Publish_Date,'%d/%m/%Y') END)Publish_Date,
//(case when Permanent='Y' then 'Yes' when Permanent='N' then 'No' end)permanent,
// (case when color is null or color='' then '#000000' else color end)color,
// (case when url is null or url='' then '../user/notice_download.aspx' else url end)url
//
// from notice_board nb
// left outer join notice_file_details fd on nb.file_id=fd.file_id
// where active='A' and status='A' and district_id=@District_id
// and case when
// permanent = 'N' then NOW() between validity_from AND Validity_To else NOW() >= Publish_Date end limit 10";
// dt = db.executeSelectQuery(qr,pm);
// return dt;
// }
//-------------------------image entry form-------------------------------------------------------------------------------//
public ReturnClass.ReturnBool Insert_notice_image(Upload_doc bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("image", bl.filename),
new MySqlParameter("user_id", bl.user_id),
new MySqlParameter("district_id", bl.district_id)
};
string qur = "insert into notice_image(image,user_id,district_id) "
+ " values(@image,@user_id,@district_id);";
rb = db.executeInsertQuery(qur, param);
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;
}
public ReturnClass.ReturnBool Update_RTIstatus(bl_employee_action bl)
{
string str = @"insert into rti_status_log select * from rti_status rd WHERE rd.rti_id =@rti_Id";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("rti_Id", bl.Rti_id)
};
string str1 = @"update rti_status set status=@status, DeptStatus=@DeptStatus ,
officer_maping_id=@ofcmapid,IPAddress=@ipaddress,action_date=@actiondate,client_browser=@clientbr,
client_OS=@clintos,useragent=@useragent,IsNew=@isnew, user_id=@userid
where rti_id=@rtiid";
MySqlParameter[] pm1 = new MySqlParameter[] {
new MySqlParameter("status", bl.Rti_status),
new MySqlParameter("DeptStatus", bl.Dept_Status),
new MySqlParameter("ofcmapid", bl.R_office_map_id),
new MySqlParameter("ipaddress", bl.Ipaddress),
new MySqlParameter("actiondate", bl.Action_date),
new MySqlParameter("clientbr", bl.User_browser),
new MySqlParameter("clintos", bl.Useros),
new MySqlParameter("useragent", bl.Useragent),
new MySqlParameter("isnew", bl.Isnew),
new MySqlParameter("userid", bl.Userid),
new MySqlParameter("rtiid", bl.Rti_id)
};
using (TransactionScope transScope = new TransactionScope())
{
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
rb = db.executeUpdateQuery(str1, pm1);
}
if (rb.status == true)
{
transScope.Complete();
}
} // Transaction end
return(rb);
}
public ReturnClass.ReturnBool Insert_Notice(Notice_Entry ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("Header", ne.Header),
new MySqlParameter("Pernament", ne.Permanent),
new MySqlParameter("Publish_Date", ne.Publish_date),
new MySqlParameter("Validity_From", ne.Datefrom),
new MySqlParameter("Validity_To", ne.Dateto),
new MySqlParameter("Active", ne.Active),
new MySqlParameter("Hyperlink", ne.Hyperlink),
new MySqlParameter("File_Type", ne.Filetype),
new MySqlParameter("File_Id", ne.file_ID),
new MySqlParameter("Url", ne.Url),
new MySqlParameter("Client_Ip", ne.Client_ip),
new MySqlParameter("User_Id", ne.User_id),
new MySqlParameter("Date_Time", ne.Datetime),
new MySqlParameter("Bold", ne.Bold),
new MySqlParameter("Blink", ne.Blink),
new MySqlParameter("Priority", ne.Priority),
new MySqlParameter("Color", ne.Color),
new MySqlParameter("Image", ne.Image),
new MySqlParameter("status", ne.status),
new MySqlParameter("district_id", ne.District_id),
new MySqlParameter("office_id", ne.Office_id),
new MySqlParameter("base_dept_id", ne.Base_dept_id)
};
string qur = @"insert into Notice_Board(Header,Permanent,Publish_Date,Validity_From,Validity_To,Active,Hyperlink,File_Type,File_Id,Url,Client_Ip,User_Id,Date_Time,
bold,blink,priority,color,image,status,district_id, base_dept_id, office_id)
values(@Header,@Pernament,@Publish_Date,@Validity_From,@Validity_To,@Active,@Hyperlink,@File_Type,@File_Id,@Url,@Client_Ip,@User_Id,@Date_Time,
@Bold,@Blink,@Priority,@Color,@Image,@status,@district_id,@base_dept_id,@office_id)";
rb = db.executeInsertQuery(qur, param);
return(rb);
}
public ReturnClass.ReturnBool Update_permission(bl_report bl)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
using (TransactionScope ts = new TransactionScope())
{
string str = @"insert into permission_log select * from permission pr where pr.emp_map_id=@eom";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("eom", bl.Office_mapping_id)
};
rb = db.executeInsertQuery(str, pm);
if (rb.status == true)
{
string str1 = @"update permission pm set pm.approve=@approve , pm.review=@review, pm.dispose=@dispose, pm.forward=@forward, pm.reject=@reject,
pm.userid=@userid, pm.ipaddress=@ipad, pm.useragent=@userage,pm.useros=@useros,pm.clientbrowser=@clientbr where pm.emp_map_id=@eom";
MySqlParameter[] pm1 = new MySqlParameter[]
{
new MySqlParameter("approve", bl.Approve),
new MySqlParameter("review", bl.Review),
new MySqlParameter("dispose", bl.Dispose),
new MySqlParameter("forward", bl.Forward),
new MySqlParameter("reject", bl.Reject),
new MySqlParameter("userid", bl.User_id),
new MySqlParameter("ipad", bl.Client_ip),
new MySqlParameter("userage", bl.Useragent),
new MySqlParameter("useros", bl.Clientos),
new MySqlParameter("clientbr", bl.ClientBrowser),
new MySqlParameter("eom", bl.Office_mapping_id)
};
rb = db.executeUpdateQuery(str1, pm1);
if (rb.status == true)
{
ts.Complete();
}
}
return(rb);
}
}
public ReturnClass.ReturnBool Insert_FileDetails(Upload_doc ne)
{
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
db_maria_connection db = new db_maria_connection();
MySqlParameter[] param = new MySqlParameter[]
{
new MySqlParameter("Header", ne.Filename),
new MySqlParameter("file_ext", ne.File_Extn),
new MySqlParameter("file_data", ne.File_Data),
new MySqlParameter("Client_Ip", ne.Client_ip),
new MySqlParameter("User_Id", ne.User_id),
new MySqlParameter("Date_Time", ne.Upload_Date)
};
string qur = "insert into notice_file_details(File_Header,mime_type,file_data,client_ip,user_code,upload_date) "
+ " values(@Header,@file_ext,@file_data,@Client_Ip,@User_Id,@Date_Time);";
rb = db.executeInsertQuery(qur, param);
return(rb);
}
}//end of Insert_rti_filed_user
public ReturnClass.ReturnBool Insert_RTI_files(bl_RTI_RequestFiles ur)
{
string strQuery = "INSERT INTO rti_files " +
"( rti_fileID, fileName, fileType, fileData, FileDescription, rti_id, BPL_RTI_FileType ) " +
" VALUES (@rti_fileID, @fileName, @fileType, @fileData,@FileDescription, @rti_requestID,@bpl_rti_FileType )";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("rti_fileID", ur.RTI_fileID),
new MySqlParameter("fileName", ur.RTI_fileName),
new MySqlParameter("fileType", ur.RTI_fileType),
new MySqlParameter("fileData", ur.RTI_fileData),
new MySqlParameter("FileDescription", ur.FileDescription),
new MySqlParameter("rti_requestID", ur.RTI_Request_id),
new MySqlParameter("bpl_rti_FileType", ur.BPL_RTI_FileType)
};
ReturnClass.ReturnBool dt = null;
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return(dt);
}//end of Insert_RTI_files
//end of Insert_Login
public ReturnClass.ReturnBool Insert_user_Registration(bl_RTI_Registration ur)
{
string strQuery = @"INSERT INTO user_registration (RegistrationID, UserID,Password, Name_hi, Name_en, Gender,MobileNo, EmailID, Address,DistrictCode,District_name,StateCode,
Country,Country_name ,PinCode, IsValid, UserType, Registration_Year, client_ip,useragent,client_os,client_browser )
VALUES (@registrationID, @userID,@Password, @nameHindi, @nameEnglish,@gender, @mobileNo, @emailID, @address, @districtCode,@distname, @statecode ,@country,
@Country_name, @pinCode,@isValid, @userType, @registration_Year,@client_ip, @useragent, @client_os, @client_browser)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("registrationID", ur.RegistrationID),
new MySqlParameter("userID", ur.UserID),
new MySqlParameter("Password", ur.Password),
new MySqlParameter("nameHindi", ur.NameHindi),
new MySqlParameter("nameEnglish", ur.NameEnglish),
new MySqlParameter("gender", ur.Gender),
new MySqlParameter("mobileNo", ur.MobileNo),
new MySqlParameter("emailID", ur.EmailID ),
new MySqlParameter("address", ur.Address),
new MySqlParameter("districtCode", ur.DistrictCode),
new MySqlParameter("distname",ur.DistrictName),
new MySqlParameter("statecode",ur.Statecode),
new MySqlParameter("country", ur.Country),
new MySqlParameter("Country_name",ur.Country_name),
new MySqlParameter("pinCode", ur.PinCode),
new MySqlParameter("isValid", ur.IsValid),
new MySqlParameter("userType", ur.UserType),
new MySqlParameter("registration_Year", ur.Registration_Year),
new MySqlParameter("client_ip",ur.UserIP),
new MySqlParameter("useragent",ur.UserAgent),
new MySqlParameter("client_os",ur.UserOS),
new MySqlParameter("client_browser",ur.User_browser)
};
ReturnClass.ReturnBool dt = new ReturnClass.ReturnBool();
db_maria_connection objDB = new db_maria_connection();
dt = objDB.executeInsertQuery(strQuery, pm);
return dt;
}
public ReturnClass.ReturnBool Insert_emp(bl_report bl)
{
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
string strQuery = @"INSERT INTO employee_table
(emp_id,user_id,Name_hi,Name_en,Active,state_id,base_department_id,district_id,NewOfficeCode,mobile_no,email_id,emp_date_time,ip_address)
VALUES(@emp_id,@user_id,@Name_hi,@Name_en,@Active,@state_id,@base_department_id,@district_id,@NewOfficeCode,@mobile_no,@email_id,@emp_date_time,@ip_address)";
MySqlParameter[] pm = new MySqlParameter[] {
new MySqlParameter("emp_id", bl.Emp_id),
new MySqlParameter("user_id", bl.User_id),
new MySqlParameter("Name_hi", bl.Name_hi),
new MySqlParameter("Name_en", bl.Name_en),
new MySqlParameter("email_id", bl.Emailid),
new MySqlParameter("Active", bl.Active),
new MySqlParameter("mobile_no", bl.Mobileno),
new MySqlParameter("district_id", bl.District_id),
new MySqlParameter("state_id", bl.State_id),
new MySqlParameter("base_department_id", bl.Department),
new MySqlParameter("NewOfficeCode", bl.NewOfficeCode),
new MySqlParameter("emp_date_time", bl.Emp_date_time),
new MySqlParameter("ip_address", bl.Client_ip)
};
rb = db.executeInsertQuery(strQuery, pm);
return(rb);
}
public ReturnClass.ReturnBool Insert_DeptUserManual(blAdmin ur)
{
db_maria_connection db = new db_maria_connection();
ReturnClass.ReturnDataTable dt = new ReturnClass.ReturnDataTable();
ReturnClass.ReturnBool rb = new ReturnClass.ReturnBool();
string strQuery = @" INSERT INTO dept_user_manual_file
(User_ID,base_department_id,office_id,office_level_id,district_id_ofc,office_category,Client_OS,ClientBrowser,UserAgent,Client_IP,file_name,content_type,
file_data,file_description, Year_Issue)
VALUES(@User_ID,@base_department_id,@office_id,@office_level_id,@district_id_ofc,@office_category,@Client_OS,@ClientBrowser,
@UserAgent,@Client_IP,@file_name,@content_type, @file_data, @file_description, @Year_Issue ) ";
MySqlParameter[] pm = new MySqlParameter[]{
new MySqlParameter("User_ID",ur.UserID),
new MySqlParameter("base_department_id",ur.Base_department_id),
new MySqlParameter("office_id",ur.Office_id),
new MySqlParameter("office_level_id",ur.Office_level_id),
new MySqlParameter("district_id_ofc",ur.District_id_ofc ),
new MySqlParameter("office_category",ur.Office_category ),
new MySqlParameter("Client_OS",ur.ClientOS),
new MySqlParameter("ClientBrowser",ur.ClientBrowser),
new MySqlParameter("UserAgent",ur.Useragent),
new MySqlParameter("Client_IP",ur.Client_ip),
new MySqlParameter("file_name",ur.FileName),
new MySqlParameter("content_type",ur.ContentType),
new MySqlParameter("file_data",ur.FileData) ,
new MySqlParameter("file_description",ur.FileDescription),
new MySqlParameter("Year_Issue",ur.Year_issue)
};
rb = db.executeInsertQuery(strQuery, pm);
return rb;
}
public ReturnBool Insert_contact_us_details(doc_ba_layer ur)
{
query = @"insert into contact_us (Name,email_id,message,mobile_no,client_ip,user_id,date_time)
values(@Name,@email_id,@message,@mobile_no,@client_ip,@user_id,@date_time)";
MySqlParameter[] pm = new MySqlParameter[]
{
new MySqlParameter("Name", ur.First_name),
new MySqlParameter("email_id", ur.Email_id),
new MySqlParameter("message", ur.Message),
new MySqlParameter("mobile_no", ur.Mobile),
new MySqlParameter("client_ip", ur.Client_id),
new MySqlParameter("user_id", ur.User_id),
new MySqlParameter("date_time", ur.Date_time)
};
rb = db.executeInsertQuery(query, pm);
return(rb);
}