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