public List <Files> PrintSubmitFormtwoRenewalData(string facId)
{
FolderCreate folder = new FolderCreate();
var list = folder.FetchFiles(facId);
return(list);
}
public List <Files> printSubmitedFormTwoDetail(String Fac_Id)
{
List <Files> list;
FolderCreate folder = new FolderCreate();
list = folder.FetchFiles(Fac_Id);
return(list);
}
public bool InsertRenewal(FormRenewal renewal)
{
FolderCreate folder = new FolderCreate();
FormTwoRenewal form = renewal.Form;
List <Files> documents = renewal.File;
bool flag = Convert.ToBoolean(dbOperation.DML("sp_ss_insert_Form2Renewal", form.F2_FAC_ID, form.FAC_DISTRICT, form.FAC_LICENSE_NO, form.LICENSE_YEARS, form.FRM_YR, form.TO_YR, form.FACTORY_NAME, form.FAC_ADD_LINE1, form.FAC_ADD_LINE2, form.FAC_PINCODE, form.FAC_PHONE_NO, form.FAC_MOBILE_NO, form.FAC_EMAIL_ID, form.FAC_POST, form.FAC_TALUK, form.COM_ADD_LINE1, form.COM_ADD_LINE2, form.COM_PINCODE, form.COM_PHONE_NO, form.COM_MOBILE_NO, form.COM_POST, form.COM_TALUK, form.COM_DISTRICT, form.NATURE_OF_MANUFACTURE_NEXT, form.NATURE_OF_MANUFACTURE_PREV, form.PRODUCT_TO_BE_MANUFACTURED, form.PROPOSED_MEN_CNT, form.PROPOSED_WOMEN_CNT, form.PROPOSED_TOTAL_CNT, form.EMPLOYED_MEN_CNT, form.EMPLOYED_WOMEN_CNT, form.EMPLOYED_TOTAL_CNT, form.TOTAL_WORKER_EMPLOYED_MEN, form.TOTAL_WORKER_EMPLOYED_WOMEN, form.TOTAL_WORKER_EMPLOYED, form.POWER_INSTLD, form.PROPOSED_POWER, form.KW_ELEC_FAC, form.MGR_NAME, form.MGR_ADD_LINE1, form.MGR_ADD_LINE2, form.MGR_PINCODE, form.MGR_MOBILE_NO, form.MGR_FATHERNAME, form.MGR_AGE, form.MGR_POST, form.MGR_TALUK, form.MGR_DISTRICT, form.OCCUPIER_NAME, form.OCCUPIER_ADD_LINE1, form.OCCUPIER_ADD_LINE2, form.OCCUPIER_PINCODE, form.OCCUPIER_PHONE_NO, form.OCCUPIER_MOBILE_NO, form.OCCUPIER_FATHERNAME, form.OCCUPIER_AGE, form.OCCUPIER_EMAIL_ID, form.OCCUPIER_POST, form.OCCUPIER_TALUK, form.OCCUPIER_DISTRICT, form.FAC_PREMISES_OWNR_NAME, form.FAC_PREMISES_OWNR_ADD_LINE1, form.FAC_PREMISES_OWNR_ADD_LINE2, form.FAC_PREMISES_OWNR_PINCODE, form.FAC_PREMISES_OWNR_PHONE_NO, form.FAC_PREMISES_OWNR_MOBILE_NO, form.FAC_PREMISES_OWNR_POST, form.FAC_PREMISES_OWNR_TALUK, form.FAC_PREMISES_OWNR_DISTRICT, form.REF_NO_DATE_OF_APPROVAL, form.REF_NO_DATE_OF_TRADE_WASTE, form.AMT_PAID, form.PAID_IN_TO, form.FEE_PAID_DATE, form.CHALLEN_NO, form.userid, form.DIVISION_CD, form.AMT_IN_WORDS));
DataSet dtls = dbOperation.DDL("usersp_FetchRenewalLicNo", form.FAC_LICENSE_NO);
var facId = dtls.Tables[0].Rows[0]["FAC_ID"].ToString();
if (flag)
{
flag = folder.CreateDirectory(facId, documents);
}
return(flag);
}
public bool InsertForm2Details(FormTwoRegistration formReg)
{
FolderCreate fc = new FolderCreate();
FormTwoEntity form = formReg.form;
bool flag = false;
try
{
List <Files> file = formReg.File;
flag = Convert.ToBoolean(operation.DML("insert_Form2", form.License_Years, form.From_Year, form.To_Year,
form.Factory_Name, form.Fac_Add_Line1, form.Fac_Add_Line2, form.Fac_Pincode, form.Fac_Phone_No, form.Fac_Post, form.Fac_Taluk, form.Fac_District, form.Fac_Mobile_No,
form.Fac_Email_Id, form.Com_Add_Line1, form.Com_Add_Line2, form.Com_Pincode, form.Com_Phone_No, form.Com_Post, form.Com_Taluk, form.Com_District, form.Com_Mobile_No,
form.Nature_Of_Manufacture_Next, form.Nature_Of_Manufacture_Prev, form.Product_To_Be_Manufactured, form.Proposed_Men_Cnt, form.Proposed_Women_Cnt, form.Proposed_Total_Cnt,
form.Employed_Men_Cnt, form.Employed_Women_Cnt, form.Employed_Total_Cnt, form.Total_Worker_Employed_Men, form.Total_Worker_Employed_Women, form.Total_Worker_Employed, form.Power_Installed,
form.Proposed_Power, form.Kw_Elec_Fac, form.Manager_Name, form.Mgr_Add_Line1, form.Mgr_Add_Line2, form.Mgr_Pincode, form.Mgr_Phone_No, form.Mgr_Post, form.Mgr_Taluk, form.Mgr_District, form.Mgr_Mobile_No,
form.Occupier_Name, form.Occupier_Add_Line1, form.Occupier_Add_Line2, form.Occupier_Pincode, form.Occupier_Phone_No, form.Occupier_Post, form.Occupier_Taluk, form.Occupier_District, form.Occupier_Mobile_No, form.Occupier_Email_Id, form.Fac_Premises_Owner_Name,
form.Fac_Premises_Owner_Add_Line1, form.Fac_Premises_Owner_Add_Line2, form.Fac_Premises_Owner_Pincode, form.Fac_Premises_Owner_Phone_No, form.Fac_Premises_Owner_Post, form.Fac_Premises_Owner_Taluk, form.Fac_Premises_Owner_District, form.Fac_Premises_Owner_Mobile_No,
form.Ref_No_Date_Of_Approval, form.Ref_No_DAate_Of_Trade_Waste, form.Amount_Paid, form.Paid_In_To, form.Fee_Paid_Date, form.Challen_No, form.Userid, form.Circle_Cd, form.Division_Cd, form.Amount_In_Words, form.CompanyType, form.NIC_Code, form.NIC_Description,
form.ASICC_Description, form.Occupier_FatherName, form.Occupier_Age, form.Manager_FatherName, form.Manager_Age));
if (flag)
{
string str = getFacIdFromForm2Details(form);
if (str != null)
{
flag = Convert.ToBoolean(fc.CreateDirectory(str, file));
}
else
{
flag = false;
}
}
}
catch (Exception e)
{
Log log = new Log();
log.LogFile("Exception:" + e.Message.ToString(), appRunningId);
}
return(flag);
}
public bool InsertForm1Details(Form1Approval formApp)
{
IOperation = new Operation();
appRunningId = Guid.NewGuid().ToString();
FormOneEntity form = formApp.form1;
FolderCreate fc = new FolderCreate();
List <Files> file = formApp.File;
bool flag = Convert.ToBoolean(IOperation.DML("sp_SS_Insert_Form_One", form.Appname, form.Designation, form.App_add_line1, form.App_add_line2, form.App_post, form.App_taluk, form.App_district, form.App_Pincode, form.Phone_no, form.Factory_add_line1, form.Factory_add_line2, form.Factory_post, form.Factory_taluk, form.Factory_district, form.Factory_pincode, form.Factory_phone_no, form.Factory_name, form.Situation_f_district, form.Situation_f_town_village, form.nearest_police_station, form.nearest_rlystation, form.buldng_approval, form.Userid, form.division_cd, form.circle_cd, form.App_mob_No1, form.Email_id, form.App_mob_No2, form.CompanyType, form.Total_wrkr_emplyd, form.Amount, form.Amt_words));
if (flag)
{
string str = GetFactId(form);
if (str != null)
{
flag = Convert.ToBoolean(fc.CreateDirectory(str, file));
}
else
{
flag = false;
}
}
return(flag);
}