//Add New Rows to fill Claims
private void AddNewRowToGrid()
{
int rowIndex = 0;
if (Session["ClaimDetails"] != null)
{
DataTable dtClaimDetails = (DataTable)Session["ClaimDetails"];
DataRow drCurrentRow = null;
if (dtClaimDetails.Rows.Count > 0 && dtClaimDetails.Rows.Count < 5)
{
for (int i = 1; i <= dtClaimDetails.Rows.Count; i++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview2.Rows[rowIndex].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview2.Rows[rowIndex].Cells[2].FindControl("TextBox2");
drCurrentRow = dtClaimDetails.NewRow();
drCurrentRow["RowNumber"] = i + 1;
dtClaimDetails.Rows[i - 1]["ClaimDescription"] = box1.Text;
dtClaimDetails.Rows[i - 1]["ClaimDate"] = box2.Text;
rowIndex++;
}
dtClaimDetails.Rows.Add(drCurrentRow);
Session["ClaimDetails"] = dtClaimDetails;
Gridview2.DataSource = dtClaimDetails;
Gridview2.DataBind();
}
}
else
{
Response.Write("ViewState is null");
}
//Set Previous Data on Postbacks
SetPreviousData();
}
protected void gvSelected_PageIndexChanging_g2(object sender, GridViewPageEventArgs e)
{
Gridview2.PageIndex = e.NewPageIndex;
Gridview2.DataBind();
}
public override View OnCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState)
{
View view = inflater.Inflate(Resource.Layout.layout_complaince, null);
task_id_to_send = Arguments.GetString("task_id") ?? string.Empty;
referencecardview = view.FindViewById <CardView>(Resource.Id.referncecardview);
Description = view.FindViewById <EditText>(Resource.Id.comment);
descrip_text = view.FindViewById <TextView>(Resource.Id.c_descrip);
name_text = view.FindViewById <TextView>(Resource.Id.c_name);
detail_text = view.FindViewById <TextView>(Resource.Id.c_detail);
markby_text = view.FindViewById <TextView>(Resource.Id.c_markby);
deadline_text = view.FindViewById <TextView>(Resource.Id.c_deadline);
createdby_text = view.FindViewById <TextView>(Resource.Id.c_createdby);
creationdate_text = view.FindViewById <TextView>(Resource.Id.c_creationdate);
camera = view.FindViewById <ImageButton>(Resource.Id.camera_btn);
video = view.FindViewById <ImageButton>(Resource.Id.video_btn);
create_by_call = view.FindViewById <ImageButton>(Resource.Id.create_by_call);
mark_by_call = view.FindViewById <ImageButton>(Resource.Id.mark_by_call);
microphone = view.FindViewById <ImageButton>(Resource.Id.micro_btn);
linear1 = view.FindViewById <LinearLayout>(Resource.Id.ll1);
linear2 = view.FindViewById <LinearLayout>(Resource.Id.ll2);
linear3 = view.FindViewById <LinearLayout>(Resource.Id.ll3);
ll_task_desc = view.FindViewById <LinearLayout>(Resource.Id.ll_task_desc);
task_desc = view.FindViewById <TextView>(Resource.Id.task_desc);
Image_no = view.FindViewById <TextView>(Resource.Id.image_no);
Video_no = view.FindViewById <TextView>(Resource.Id.video_no);
Audio_no = view.FindViewById <TextView>(Resource.Id.audio_no);
comment_micro = view.FindViewById <ImageView>(Resource.Id.comment_micro);
Submit_Btn = view.FindViewById <Button>(Resource.Id.submit);
uploadimage = view.FindViewById <TextView>(Resource.Id.uploaded_no1);
uploadvideo = view.FindViewById <TextView>(Resource.Id.uploaded_no2);
uploadaudio = view.FindViewById <TextView>(Resource.Id.uploaded_no3);
Gridview1 = view.FindViewById <ExpandableHeightGridView>(Resource.Id.gridView1);
Gridview2 = view.FindViewById <ExpandableHeightGridView>(Resource.Id.gridView2);
Gridview3 = view.FindViewById <ExpandableHeightGridView>(Resource.Id.gridView3);
progress = new Android.App.ProgressDialog(Activity);
progress.Indeterminate = true;
progress.SetProgressStyle(Android.App.ProgressDialogStyle.Spinner);
progress.SetCancelable(false);
progress.SetMessage("Please wait...");
referencecardview.Click += delegate
{
ReferenceAttachmentActivity reference = new ReferenceAttachmentActivity();
Android.Support.V4.App.FragmentTransaction ft = FragmentManager.BeginTransaction();
//ft.Replace(Resource.Id.container, reference);
ft.Hide(FragmentManager.FindFragmentByTag("ComplainceFragment"));
ft.Add(Resource.Id.container, reference);
ft.AddToBackStack(null);
ft.SetTransition(FragmentTransaction.TransitFragmentOpen);
ft.Commit();
Bundle bundle = new Bundle();
bundle.PutString("TaskId", task_id_to_send);
reference.Arguments = bundle;
};
create_by_call.Click += delegate
{
try
{
var hasTelephony = Activity.PackageManager.HasSystemFeature(PackageManager.FeatureTelephony);
if (hasTelephony)
{
//var uri = Android.Net.Uri.Parse("tel:" +creat_by_num);
var uri = Android.Net.Uri.Parse("tel:" + "9984059984");
var intent = new Intent(Intent.ActionDial, uri);
Activity.StartActivity(intent);
}
}
catch (System.Exception e) { }
};
mark_by_call.Click += delegate
{
try
{
var hasTelephony = Activity.PackageManager.HasSystemFeature(PackageManager.FeatureTelephony);
if (hasTelephony)
{
// var uri = Android.Net.Uri.Parse("tel:" +mark_by_num);
var uri = Android.Net.Uri.Parse("tel:" + "9984059984");
var intent = new Intent(Intent.ActionDial, uri);
Activity.StartActivity(intent);
}
}
catch (System.Exception e) { }
};
Gridview1.setExpanded(true);
//Gridview1.ChoiceMode = (ChoiceMode)AbsListViewChoiceMode.MultipleModal;
//Gridview1.SetMultiChoiceModeListener(new MultiChoiceModeListener1(Activity));
Gridview2.setExpanded(true);
//Gridview2.ChoiceMode = (ChoiceMode)AbsListViewChoiceMode.MultipleModal;
//Gridview2.SetMultiChoiceModeListener(new MultiChoiceModeListener2(Activity));
Gridview3.setExpanded(true);
//Gridview3.ChoiceMode = (ChoiceMode)AbsListViewChoiceMode.MultipleModal;
//Gridview3.SetMultiChoiceModeListener(new MultiChoiceModeListener3(Activity));
//if (ic.connectivity())
//{
getDataFromServer();
//}
//else
// {
//}
//attachmentData = db.GetComp_Attachments(task_id_to_send);
//if (attachmentData != null)
//{
// for (int i = 0; i < attachmentData.Count; i++)
// {
// if (attachmentData[i].file_type.Equals("Image"))
// {
// imagelist.Add(attachmentData[i]);
// }
// else if (attachmentData[i].file_type.Equals("Video"))
// {
// videolist.Add(attachmentData[i]);
// }
// else if (attachmentData[i].file_type.Equals("Audio"))
// {
// audiolist.Add(attachmentData[i]);
// }
// }
// adapter1 = new GridViewAdapter_Image(Activity, imagelist);
// Gridview1.Adapter = adapter1;
// adapter2 = new GridViewAdapter_Video(Activity, videolist);
// Gridview2.Adapter = adapter2;
// adapter3 = new GridViewAdapter_Audio(Activity, audiolist);
// Gridview3.Adapter = adapter3;
//}
camera.Click += delegate
{
Click_Type = "Camera";
CheckForShapeData_Camera();
};
video.Click += delegate
{
Click_Type = "Video";
CheckForShapeData_Video();
};
microphone.Click += delegate
{
if (audio_comp_lst.Count < aud_max)
{
if (shapes1 != null)
{
if (CheckForShape())
{
recording();
}
else
{
Toast.MakeText(Activity, "you are outside marked area", ToastLength.Long).Show();
}
}
else
{
recording();
}
}
};
Submit_Btn.Click += delegate
{
Submit_Method();
};
comment_micro.Click += delegate
{
CheckMicrophone();
};
return(view);
}
protected void odswiez()
{
string idDzialu = (string)Session["id_dzialu"];
string txt = string.Empty;
DataTable tabelkaGW1 = new DataTable();
DataTable tabelkaGW2 = new DataTable();
DataTable tabelkaGW3 = new DataTable();
DataTable tabelkaGW4 = new DataTable();
DataTable tabelkaGW5 = new DataTable();
DataTable tabelkaGW6 = new DataTable();
DataTable tabelkaGW7 = new DataTable();
DataTable tabelkaGW8 = new DataTable();
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 1");
tabelkaGW1 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 1, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka001"] = tabelkaGW1;
Tabela1.DataSource = null;
Tabela1.DataSourceID = null;
Tabela1.DataSource = tabelkaGW1;
Tabela1.DataBind();
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 2");
tabelkaGW2 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 2, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka002"] = tabelkaGW2;
Gridview2.DataSource = null;
Gridview2.DataSourceID = null;
Gridview2.DataSource = tabelkaGW2;
Gridview2.DataBind();
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 3");
tabelkaGW3 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse((string)Session["id_dzialu"]), 3, Date1.Date, Date2.Date, 30, tenPlik);
Session["tabelka003"] = tabelkaGW3;
Gridview3.DataSource = null;
Gridview3.DataSourceID = null;
Gridview3.DataSource = tabelkaGW3;
Gridview3.DataBind();
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 4");
tabelkaGW4 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 4, 1, 8, tenPlik);
Session["tabelka004"] = tabelkaGW4;
//pisz("tab_05_", 10, 9, tabela02);
tab_05_w01_c1.Text = tabelkaGW4.Rows[0][1].ToString().Trim();
tab_05_w01_c2.Text = tabelkaGW4.Rows[0][2].ToString().Trim();
tab_05_w01_c3.Text = tabelkaGW4.Rows[0][3].ToString().Trim();
tab_05_w01_c4.Text = tabelkaGW4.Rows[0][4].ToString().Trim();
tab_05_w01_c5.Text = tabelkaGW4.Rows[0][5].ToString().Trim();
tab_05_w01_c6.Text = tabelkaGW4.Rows[0][6].ToString().Trim();
tab_05_w01_c7.Text = tabelkaGW4.Rows[0][7].ToString().Trim();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " tabela 4 " + ex.Message);
}
try
{
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 5");
tabelkaGW5 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 5, 8, 2, tenPlik);
Session["tabelka005"] = tabelkaGW5;
tab_06_w01_c01.Text = tabelkaGW5.Rows[0][1].ToString().Trim();
tab_06_w02_c01.Text = tabelkaGW5.Rows[1][1].ToString().Trim();
tab_06_w03_c01.Text = tabelkaGW5.Rows[2][1].ToString().Trim();
tab_06_w04_c01.Text = tabelkaGW5.Rows[3][1].ToString().Trim();
tab_06_w05_c01.Text = tabelkaGW5.Rows[4][1].ToString().Trim();
tab_06_w06_c01.Text = tabelkaGW5.Rows[5][1].ToString().Trim();
tab_06_w07_c01.Text = tabelkaGW5.Rows[6][1].ToString().Trim();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
try
{
Session["tabelka006"] = dr.tworzTabele(int.Parse((string)Session["id_dzialu"]), 6, Date1.Date, Date2.Date, 30, Gridview6, tenPlik);
Gridview6.DataBind();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
//cm.log.Info("OGLR2: wczytywanie danych do tabeli 7");
Session["tabelka007"] = dr.tworzTabele(int.Parse((string)Session["id_dzialu"]), 7, Date1.Date, Date2.Date, 9, Gridview7, tenPlik);
Gridview7.DataBind();
}
catch (Exception ex)
{
cm.log.Error("OGLR2: " + ex.Message);
}
// dopasowanie opisów
makeLabels();
try
{
Label11.Visible = cl.debug(int.Parse(idDzialu));
infoLabel2.Visible = cl.debug(int.Parse(idDzialu));
infoLabel3.Visible = cl.debug(int.Parse(idDzialu));
infoLabel4.Visible = cl.debug(int.Parse(idDzialu));
infoLabel5.Visible = cl.debug(int.Parse(idDzialu));
infoLabel5.Visible = cl.debug(int.Parse(idDzialu));
infoLabel7.Visible = cl.debug(int.Parse(idDzialu));
infoLabel8.Visible = cl.debug(int.Parse(idDzialu));
}
catch
{
Label11.Visible = false;
infoLabel2.Visible = false;
infoLabel3.Visible = false;
infoLabel4.Visible = false;
infoLabel5.Visible = false;
infoLabel6.Visible = false;
infoLabel7.Visible = false;
infoLabel8.Visible = false;
}
Label11.Text = txt;
Label3.Text = cl.nazwaSadu((string)Session["id_dzialu"]);
}
protected override void OnActivityResult(int requestCode, [GeneratedEnum] Result resultCode, Intent data)
{
base.OnActivityResult(requestCode, resultCode, data);
if (requestCode == Camera)
{
Bitmap bitmap = BitmapFactory.DecodeFile(imageURL);
Comp_AttachmentModel attachmentModel = new Comp_AttachmentModel();
attachmentModel.Attachment_Path = AudioSavePathInDevice;
attachmentModel.Attachment_Type = "Image";
attachmentModel.Attachment_Name = audioname;
attachmentModel.Task_id = task_id_to_send;
db.InsertAttachmentData(attachmentModel);
//comp_AttachmentModels.Add(attachmentModel);
//imagelist.AddRange(comp_AttachmentModels.Where(p => p.Attachment_Type == "Image" ));
imagelist = db.GetAttachmentData("Image");
adapter1 = new GridViewAdapter_Image(this, imagelist);
Gridview1.Adapter = adapter1;
Gridview1.setExpanded(true);
Gridview1.ChoiceMode = (ChoiceMode)AbsListViewChoiceMode.MultipleModal;
Gridview1.SetMultiChoiceModeListener(new MultiChoiceModeListener1(this));
imageCount++;
}
if (requestCode == Video)
{
Comp_AttachmentModel attachmentModel = new Comp_AttachmentModel();
attachmentModel.Attachment_Path = AudioSavePathInDevice;
attachmentModel.Attachment_Type = "Video";
attachmentModel.Attachment_Name = audioname;
attachmentModel.Task_id = task_id_to_send;
db.InsertAttachmentData(attachmentModel);
//comp_AttachmentModels.Add(attachmentModel);
//imagelist.AddRange(comp_AttachmentModels.Where(p => p.Attachment_Type == "Image" ));
videolist = db.GetAttachmentData("Video");
adapter2 = new GridViewAdapter_Video(this, videolist);
Gridview2.Adapter = adapter2;
Gridview2.setExpanded(true);
Gridview2.ChoiceMode = (ChoiceMode)AbsListViewChoiceMode.MultipleModal;
Gridview2.SetMultiChoiceModeListener(new MultiChoiceModeListener2(this));
videoCount++;
}
if (requestCode == VOICE)
{
var matches = data.GetStringArrayListExtra(RecognizerIntent.ExtraResults);
if (matches.Count != 0)
{
string textInput = Description.Text + matches[0];
// limit the output to 500 characters
if (textInput.Length > 500)
{
textInput = textInput.Substring(0, 500);
}
Description.Text = textInput;
}
else
{
Description.Text = "No speech was recognised";
}
}
}
private void BindGriview2(string condition)
{
Gridview2.DataSource = psd.SelectProType_Special(condition);
Gridview2.DataBind();
}
//绑定进度表
private void BindGridview2(string condition)
{
Gridview2.DataSource = ccl.SelectCRMNewCustormDevelop(condition);
Gridview2.DataBind();
}
//Add newly entered Driver details to the Policy
public void Button1_Click(object sender, EventArgs e)
{
this.btnCalcPremium.Disabled = false;
if ((Request.Form[txtPolicyStartDate.UniqueID]) == string.Empty)
{
this.lblMessage.Text = "Please fill in Required Columns.";
return;
}
if ((Request.Form[this.txtDateOfBirth.UniqueID]) == string.Empty)
{
this.lblMessage.Text = "Please fill in Required Columns.";
return;
}
if (txtDriverName.Text == string.Empty)
{
this.lblMessage.Text = "Please fill in Required Columns.";
return;
}
int rowcnt = 0;
DataTable Claimdt = new DataTable();
Claimdt = (DataTable)Session["ClaimDetails"];
List <DriverDetails> objListDriver = (List <DriverDetails>)Session["DriverLists"];
DriverDetails obj = new DriverDetails();
obj.driverName = this.txtDriverName.Text;
obj.occupation = this.lstOccupation.Text;
obj.dateofbirth = this.txtDateOfBirth.Text;
obj.claimcount = Gridview2.Rows.Count;
DataTable DriverClaimDetails = new DataTable();
DriverClaimDetails = (DataTable)Session["DriverClaimDetails"];
if (Gridview2.Rows.Count > 0)
{
for (rowcnt = 0; rowcnt < Gridview2.Rows.Count; rowcnt++)
{
//extract the TextBox values
TextBox box1 = (TextBox)Gridview2.Rows[rowcnt].Cells[1].FindControl("TextBox1");
TextBox box2 = (TextBox)Gridview2.Rows[rowcnt].Cells[2].FindControl("TextBox2");
obj.claimlist.Add(new ClaimDetails {
rownumber = rowcnt + 1, claimdescription = box1.Text.ToString(), claimDate = Convert.ToDateTime(box2.Text)
});
DataRow dr = null;
dr = DriverClaimDetails.NewRow();
dr["RowNumber"] = DriverClaimDetails.Rows.Count;
dr["DriverName"] = this.txtDriverName.Text;
dr["DriverOccupation"] = this.lstOccupation.Text;
dr["DriverDateOfBirth"] = this.txtDateOfBirth.Text;
dr["ClaimDescription"] = box1.Text;
dr["ClaimDate"] = box2.Text;
DriverClaimDetails.Rows.Add(dr);
}
}
else
{
DataRow dr = null;
dr = DriverClaimDetails.NewRow();
dr["RowNumber"] = DriverClaimDetails.Rows.Count;
dr["DriverName"] = this.txtDriverName.Text;
dr["DriverOccupation"] = this.lstOccupation.Text;
dr["DriverDateOfBirth"] = this.txtDateOfBirth.Text;
dr["ClaimDescription"] = String.Empty;
dr["ClaimDate"] = String.Empty;
DriverClaimDetails.Rows.Add(dr);
}
//Store the DataTable in session
Session["DriverClaimDetails"] = DriverClaimDetails;
//Method to display Driver with Claim Details as Table data
SetDriverClaimsTableFilledRow();
objListDriver.Add(obj);
Session["DriverLists"] = objListDriver;
//Reset Driver Details
this.txtDriverName.Text = null;
this.txtDateOfBirth.Text = null;
if (Claimdt != null)
{
for (int i = Claimdt.Rows.Count - 1; i >= 0; i--)
{
DataRow dr = Claimdt.Rows[i];
Claimdt.Rows.Remove(dr);
}
}
Gridview2.DataSource = Claimdt;
Gridview2.DataBind();
this.Gridview2.Visible = false;
if (objListDriver.Count == 5)
{
this.lblMessage.Text = "Insurance can have Maximun 5 Drivers only.";
this.btnAddDriver.Disabled = true;
this.btnAddClaims.Disabled = true;
return;
}
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn RECOM_TEXT = new DataColumn();
RECOM_TEXT.DataType = Type.GetType("System.String");
RECOM_TEXT.ColumnName = "RECOM_TEXT";
dt.Columns.Add(RECOM_TEXT);
DataColumn RECOMD_DESC = new DataColumn();
RECOMD_DESC.DataType = Type.GetType("System.String");
RECOMD_DESC.ColumnName = "RECOMD_DESC";
dt.Columns.Add(RECOMD_DESC);
DataColumn RECOM_ID = new DataColumn();
RECOM_ID.DataType = Type.GetType("System.String");
RECOM_ID.ColumnName = "RECOM_ID";
dt.Columns.Add(RECOM_ID);
DataColumn RECOMD_ID = new DataColumn();
RECOMD_ID.DataType = Type.GetType("System.String");
RECOMD_ID.ColumnName = "RECOMD_ID";
dt.Columns.Add(RECOMD_ID);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
try
{
ValidateUserAccess();
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("RECOM_ID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_RECOMMENDATION_MASTER"));
DataTable dt2 = DBManager.Get(vHashtable, "GET_RECOMMENDATION_MASTER");
if (vDR != null)
{
TXTID.Value = vDR["RECOM_ID"].ToString();
RECO_TXT.Text = vDR["RECOM_TEXT"].ToString();
Textarea1.InnerText = vDR["RECOMD_DESC"].ToString();
Gridview2.DataSource = dt2;
Gridview2.DataBind();
RECO_TXT.Enabled = false;
Templatenew.Visible = false;
Gridview2.HeaderRow.Cells[04].Visible = false;
foreach (GridViewRow gdr in Gridview2.Rows)
{
gdr.Cells[04].Visible = false;
}
}
else
{
ShowMsg("Invalid Recommendation ID");
}
}
}
catch (Exception xe)
{
ShowMsg(xe);
}
}
}
//正料表绑定
private void BindGridview2(PMCopperFoundryinfo PMCopperFoundryinfo)
{
Gridview2.DataSource = pf.SelectPMCopperIn(PMCopperFoundryinfo);
Gridview2.DataBind();
}
//进度明细表绑定
private void BindGridview2(PRMProjectinfo PRMProjectinfo)
{
Gridview2.DataSource = ppm.SelectPRMProject_Schedule(PRMProjectinfo);
Gridview2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
if (!IsPostBack)
{
dt = new DataTable();
DataColumn DCAT_NAME = new DataColumn();
DCAT_NAME.DataType = Type.GetType("System.String");
DCAT_NAME.ColumnName = "DCAT_NAME";
dt.Columns.Add(DCAT_NAME);
DataColumn DSCAT_DESC = new DataColumn();
DSCAT_DESC.DataType = Type.GetType("System.String");
DSCAT_DESC.ColumnName = "DSCAT_DESC";
dt.Columns.Add(DSCAT_DESC);
DataColumn IEPMD_NAME = new DataColumn();
IEPMD_NAME.DataType = Type.GetType("System.String");
IEPMD_NAME.ColumnName = "IEPMD_NAME";
dt.Columns.Add(IEPMD_NAME);
DataColumn IEPMD_DESC = new DataColumn();
IEPMD_DESC.DataType = Type.GetType("System.String");
IEPMD_DESC.ColumnName = "IEPMD_DESC";
dt.Columns.Add(IEPMD_DESC);
DataColumn DCAT_ID = new DataColumn();
DCAT_ID.DataType = Type.GetType("System.String");
DCAT_ID.ColumnName = "DCAT_ID";
dt.Columns.Add(DCAT_ID);
DataColumn DSCAT_ID = new DataColumn();
DSCAT_ID.DataType = Type.GetType("System.String");
DSCAT_ID.ColumnName = "DSCAT_ID";
dt.Columns.Add(DSCAT_ID);
DataColumn IEPMD_ID = new DataColumn();
IEPMD_ID.DataType = Type.GetType("System.String");
IEPMD_ID.ColumnName = "IEPMD_ID";
dt.Columns.Add(IEPMD_ID);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
try
{
ValidateUserAccess();
ATCommon.FillDrpDown(DDLCAT, DBManager.Get(new Hashtable(), "CMB_DIS_CAT_MASTER"), "Select Category Name", "DCAT_NAME", "DCAT_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("IEPMD_IEPMID", vID);
vHashtable.Add("TYPE", "GET");
DataRow vDR = RetDR(DBManager.Get(vHashtable, "GET_IEP_MAPPING_ID"));
DataTable dt2 = DBManager.Get(vHashtable, "GET_IEP_MAPPING_ID");
if (vDR != null)
{
TXTID.Value = vDR["IEPM_ID"].ToString();
Gridview2.DataSource = dt2;
Gridview2.DataBind();
Templatenew.Visible = false;
btnSave.Visible = true;
}
else
{
ShowMsg("Invalid IEP Mapping ID");
}
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
public void fillgrid()
{
DataTable dtmycount = select("select distinct [CompanyId] from CompanyLogoDisplay");
DataTable s11 = new DataTable();
DataTable s12 = new DataTable();
if (dtmycount.Rows.Count > 0)
{
for (int i = 0; i < dtmycount.Rows.Count; i++)
{
s11 = select("select TOP(1) CompanyLogoDisplay.ID,CompanyWebsitMaster.CompanyId,CompanyWebsitMaster.logourl,CompanyWebsitMaster.Sitename,CompanyWebsitMaster.Sitename as location,CompanyLogoDisplay.EverywhereDisplay,CompanyLogoDisplay.CountryID,CompanyLogoDisplay.StateID,CompanyLogoDisplay.CityID,CountryMaster.CountryName,StateMasterTbl.StateName,CityMasterTbl.CityName,CountryMaster.CountryId as Country1,StateMasterTbl.StateId as State1,CityMasterTbl.CityId as City1 from CompanyWebsitMaster inner join CompanyWebsiteAddressMaster on CompanyWebsiteAddressMaster.CompanyWebsiteMasterId=CompanyWebsitMaster.Whid inner join CountryMaster on CountryMaster.CountryId=CompanyWebsiteAddressMaster.Country inner join StateMasterTbl on StateMasterTbl.StateId=CompanyWebsiteAddressMaster.State inner join CityMasterTbl on CityMasterTbl.CityId=CompanyWebsiteAddressMaster.City inner join CompanyLogoDisplay on CompanyLogoDisplay.CompanyID=CompanyWebsitMaster.CompanyId where CompanyLogoDisplay.CompanyID='" + dtmycount.Rows[i]["CompanyId"].ToString() + "' order by CompanyWebsitMaster.CompanyWebsiteMasterId asc");
s12.Merge(s11);
}
Gridview2.DataSource = s12;
Gridview2.DataBind();
foreach (GridViewRow ggg in Gridview2.Rows)
{
Label lbllocation = (Label)ggg.FindControl("lbllocation");
Label lbllogevry = (Label)ggg.FindControl("lbllogevry");
Label lbllogcoun = (Label)ggg.FindControl("lbllogcoun");
Label lbllogstat = (Label)ggg.FindControl("lbllogstat");
Label lbllogcity = (Label)ggg.FindControl("lbllogcity");
Image image1 = (Image)ggg.FindControl("Image1001");
image1.ImageUrl = "~/ShoppingCart/images/" + image1.ImageUrl;
if (lbllogevry == null)
{
}
else
{
if (lbllogevry.Text == "1")
{
lbllocation.Text = "Everywhere";
}
}
if (lbllogcoun == null)
{
}
else
{
if (lbllogcoun.Text != "0")
{
lbllocation.Text = "Entire Country";
}
}
if (lbllogstat == null)
{
}
else
{
if (lbllogstat.Text != "0")
{
lbllocation.Text = "Entire State";
}
}
if (lbllogcity == null)
{
}
else
{
if (lbllogcity.Text != "0")
{
lbllocation.Text = "Entire City";
}
}
}
}
else
{
Gridview2.DataSource = null;
Gridview2.DataBind();
}
}
protected void BindSupply()
{
Gridview2.DataSource = pp.Select_Supply(LabelSupplyID.Text.ToString());
Gridview2.DataBind();
UpdatePanel4.Update();
}
protected void odswiez()
{
string idDzialu = (string)Session["id_dzialu"];
//id_dzialu.Text = (string)Session["txt_dzialu"];
string txt = string.Empty; //
cl.deleteRowTable();
try
{
DataTable tabelka02 = dr.generuj_dane_do_tabeli_wierszy2018(Date1.Date, Date2.Date, (string)Session["id_dzialu"], 2, 11, 14, tenPlik);
Session["tabelka002"] = tabelka02;
//tabela 1
try
{
cm.log.Info(tenPlik + ": rozpoczęcie tworzenia tabeli 1");
DataTable Tabela1 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse(idDzialu), 1, Date1.Date, Date2.Date, 25, tenPlik);
Session["tabelka001"] = Tabela1;
Gridview1.DataSource = null;
Gridview1.DataSourceID = null;
Gridview1.DataSource = Tabela1;
Gridview1.DataBind();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " tabela 1 " + ex.Message);
}
try
{
cm.log.Info(tenPlik + ": rozpoczęcie tworzenia tabeli 3");
DataTable Tabela1 = dr.generuj_dane_do_tabeli_sedziowskiej_2019(int.Parse(idDzialu), 3, Date1.Date, Date2.Date, 18, tenPlik);
Session["tabelka003"] = Tabela1;
Gridview2.DataSource = null;
Gridview2.DataSourceID = null;
Gridview2.DataSource = Tabela1;
Gridview2.DataBind();
}
catch (Exception ex)
{
cm.log.Error(tenPlik + " tabela 3 " + ex.Message);
}
}
catch (Exception ex)
{
cm.log.Error(tenPlik + ex.Message);
}
// dopasowanie opisów
makeLabels();
try
{
Label11.Visible = cl.debug(int.Parse(idDzialu));
infoLabel2.Visible = cl.debug(int.Parse(idDzialu));
infoLabel3.Visible = cl.debug(int.Parse(idDzialu));
}
catch
{
Label11.Visible = false;
infoLabel2.Visible = false;
infoLabel3.Visible = false;
}
Label11.Text = txt;
Label3.Text = cl.nazwaSadu((string)Session["id_dzialu"]);
}
//绑定供应商
private void BindGridview2(string Condition)
{
Gridview2.DataSource = ppl.SelectPMSupplyInfo(Condition);
Gridview2.DataBind();
}
//相应供应商的采购付款详细表
private void BindGridview2(PMPaymentBillinfo PMPaymentBillinfo)
{
Gridview2.DataSource = ppb.SelectPMPaymentIDetail(PMPaymentBillinfo);
Gridview2.DataBind();
}
//采购订单详细表
private void BindGridview2(PMPurchaseOrderinfo PMPurchaseOrderinfo)
{
Gridview2.DataSource = pl.SelectPMPurchaseOrderDetail_look(PMPurchaseOrderinfo);
Gridview2.DataBind();
}
protected void Page_Load(object sender, EventArgs e)
{
vATSession = (ATSession)Session["User"];
if (vATSession == null)
{
Response.Redirect("Default.aspx");
}
String vID = Request.QueryString["ID"];
string strPreviousPage = string.Empty;
if (Request.UrlReferrer != null)
{
strPreviousPage = Request.UrlReferrer.Segments[Request.UrlReferrer.Segments.Length - 1];
}
if (strPreviousPage == "")
{
Response.Redirect("~/Default.aspx");
}
if (!IsPostBack)
{
dt = new DataTable();
DataColumn RECOM_TEXT = new DataColumn();
RECOM_TEXT.DataType = Type.GetType("System.String");
RECOM_TEXT.ColumnName = "RECOM_TEXT";
dt.Columns.Add(RECOM_TEXT);
DataColumn RECOMD_DESC = new DataColumn();
RECOMD_DESC.DataType = Type.GetType("System.String");
RECOMD_DESC.ColumnName = "RECOMD_DESC";
dt.Columns.Add(RECOMD_DESC);
DataColumn RECOM_ID = new DataColumn();
RECOM_ID.DataType = Type.GetType("System.String");
RECOM_ID.ColumnName = "RECOM_ID";
dt.Columns.Add(RECOM_ID);
DataColumn RECOMD_ID = new DataColumn();
RECOMD_ID.DataType = Type.GetType("System.String");
RECOMD_ID.ColumnName = "RECOMD_ID";
dt.Columns.Add(RECOMD_ID);
ViewState["datagrid"] = dt;
BindGrid();
Clear();
try
{
ValidateUserAccess();
Label1.Text = "<b>Step 1</b>-You can select a given category and corresponding to that category is the set of recommendations given for your reference. You may choose those which are useful for your patient. You can add as many recommendations as you wish to, if at any stage you want to delete any recommendation, you can do so by clicking the <b>'cross'</b>." +
"<br><b>Step 2</b>- Once you have added you recommendations, you can save them. At any given point in time, you want to add more recommendations, you can do so. The recommendations which you have <b>'Saved'</b> will be included in your patients PDF report. </ br>";
ATCommon.FillDrpDown(DDLRECOMMENDATION, DBManager.Get(new Hashtable(), "CMB_RECOMMENDATION"), "Select Recommendation Name", "RECOM_TEXT", "RECOM_ID", "0");
if (vID != null)
{
Hashtable vHashtable = new Hashtable();
vHashtable.Add("PTP_ID", vID);
vHashtable.Add("TYPE", "GET");
DataTable dt2 = DBManager.Get(vHashtable, "GET_RECOMMENDATION_MAPPING");
Gridview2.DataSource = dt2;
Gridview2.DataBind();
Templatenew.Visible = false;
}
}
catch (Exception xe) { ShowMsg(xe); }
}
}
