public FormOneEntity getform1details(string Userid) { FormOneEntity form = new FormOneEntity(); try { DataSet ds = operation.DDL("Sp_fetch_Form1_dtls", Userid); foreach (DataRow item in ds.Tables[0].Rows) { form.Factory_add_line1 = item[0].ToString(); form.Factory_add_line2 = item[1].ToString(); form.Factory_pincode = item[2].ToString(); form.Factory_phone_no = item[3].ToString(); form.App_mob_No2 = item[4].ToString(); form.Factory_post = item[5].ToString(); form.Factory_taluk = item[6].ToString(); form.Factory_district = item[7].ToString(); form.Factory_name = item[8].ToString(); } } catch (Exception e) { Log log = new Log(); log.LogFile("Exception:" + e.Message.ToString(), appRunningId); } return(form); }
//By usha on 13/02/2020 to Posting data to sakala public string GetFactId(FormOneEntity form) { string fac_name = form.Factory_name; string fac_pincode = form.Factory_pincode; string Fac_id = null; DataSet ds = IOperation.DDL("Sp_Fac_Id", fac_name, fac_pincode); foreach (DataRow item in ds.Tables[0].Rows) { Fac_id = item[0].ToString(); } return(Fac_id); }
public bool UpdateVerifierForm1Details(FormOneEntity form) { bool flag = Convert.ToBoolean(IOperation.DML("sp_Updat_Form1ByAppStatus", form.division_cd, form.Forwarded_divCd, form.Remarks, form.Fac_id)); if (flag) { flag = true; } else { flag = false; } return(flag); }
public bool UpdateApproverForm1Details(FormOneEntity form) { bool flag = false; string Status = null; if (form.Action == "Rejected") { Status = "SR"; flag = Convert.ToBoolean(IOperation.DML("sp_Update_RejectedForm ", form.Fac_id, Status, form.Remarks)); } else if (form.Action == "Forward") { if (form.Forward_To == "User") { DataSet ds = IOperation.DDL("sp_Get_BacktoUser", form.Fac_id); string FDiv_Cd = ds.Tables[0].Rows[0]["Forwarded_divCd"].ToString(); Status = "SI"; flag = Convert.ToBoolean(IOperation.DML("sp_Update_BacktoUser", form.Fac_id, Status, FDiv_Cd, form.Remarks)); } else if (form.Forward_To == "Approver") { DataSet ds = IOperation.DDL("sp_Get_BacktoApprover", form.Fac_id); string Remarks = ds.Tables[0].Rows[0]["Back_Remarks"].ToString(); Status = "SV"; flag = Convert.ToBoolean(IOperation.DML("sp_Update_BacktoApprover", form.Fac_id, Status, form.division_cd, Remarks)); } } else if (form.Action == "Approve") { Status = "SA"; flag = Convert.ToBoolean(IOperation.DML("sp_Update_ApprovedForm1_dtls ", form.Fac_id, Status, form.Remarks, form.ApplicationNumber, form.Conditions)); } if (flag) { flag = true; } else { flag = false; } return(flag); }
private Form1Approval getAlldata() { var formone = new Form1Approval(); FormOneEntity form = new FormOneEntity(); // formone=new {form1={ form.Appname = "Shivashankar"; form.Designation = "Manager"; form.App_add_line1 = "BENGALURU"; form.App_add_line2 = "BENGALURU"; form.App_post = "Anekal"; form.App_taluk = "Anekal"; form.App_district = "BENGALURU"; form.App_Pincode = "560040"; form.Phone_no = "7899285626"; form.Factory_add_line1 = "BENGALURU"; form.Factory_add_line2 = "BENGALURU"; form.Factory_post = "Anekal"; form.Factory_taluk = "Anekal"; form.Factory_district = "BENGALURU"; form.Factory_pincode = "560040"; form.Factory_phone_no = "7899285626"; form.Factory_name = "Sugar"; form.Situation_f_district = "BENGALURU"; form.Situation_f_town_village = "town"; form.nearest_police_station = "yes"; form.nearest_rlystation = "yes"; form.buldng_approval = "Proposed Building"; form.Userid = "Demo"; form.division_cd = "Senior Assistant Director of Factories, Bangalore Division-10"; form.circle_cd = "BANGALORE REGION"; form.App_mob_No1 = "8656565655"; form.Email_id = "*****@*****.**"; form.App_mob_No2 = "8565652322"; form.CompanyType = "Proprietory"; form.Total_wrkr_emplyd = 21; form.Amount = "100"; form.Amt_words = "One Hundred"; formone.form1 = form; formone.File = null; return(formone); }
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); }