public Game(string connStr)
{
InitBoard();
BL.BL bl = new BL.BL(connStr);
this.randomWord = bl.GetRandomWord();
this.turn = 0;
}
/// <summary>
/// Update the password using md5 for the created user.
/// </summary>
private void UpdatePassword()
{
TextBox Password = (TextBox)RegisterUser.CreateUserStep.ContentTemplateContainer.FindControl("Password");
MAHAITDBAccess = new BL.BL(System.Configuration.ConfigurationManager.AppSettings["APPID"].ToString());
SqlCommand cmd = new SqlCommand();
cmd.Parameters.AddWithValue("@UserName ", RegisterUser.UserName);
cmd.Parameters.AddWithValue("@Password ", Password.Text);
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "[uspUpdateUserPassword]";
cmd.CommandTimeout = 1000;
MAHAITDBAccess.ExecuteNonQuery(cmd);
}
private void InitialiseShopsList()
{
bl = BL.BL.GetInstance();
shopsList = new List <Shop>(bl.GetAllShops());
//shopsList = new ObservableCollection<Shop>
//{
// new Shop { Name = "Tip Top Shop 1", Address = "Rue du Lt Jean Vigneux, Saint Gratien, France", Location = new Location { Latitude = 32, Longitude = 35.191130 }, Phone = "157", Website = "google.fr", ImageURL="C:/Users/gabri/Pictures/m1.jpg", Supply = new ObservableCollection<IceCream> { new IceCream() } },
// new Shop { Name = "Tip Top Shop 2", Address = "Rue du Lt Jean Vigneux, Saint Gratien, France", Location = new Location { Latitude = 34, Longitude = 35.191132 }, Phone = "135", Website = "google.com", ImageURL="C:/Users/gabri/Pictures/m1.jpg", Supply = new ObservableCollection<IceCream> { } },
// new Shop { Name = "Tip Top Shop 3", Address = "Rue du Lt Jean Vigneux, Saint Gratien, France", Location = new Location { Latitude = 36.765192, Longitude = 35.191134 }, Phone = "0123", Website = "google.co.it", ImageURL="C:/Users/gabri/Pictures/m1.jpg", Supply = new ObservableCollection<IceCream> { new IceCream(), new IceCream() } },
// new Shop { Name = "Tip Top Shop 4", Address = "Rue du Lt Jean Vigneux, Saint Gratien, France", Location = new Location { Latitude = 38.765192, Longitude = 35.191134 }, Phone = "0123", Website = "google.co.it", ImageURL="C:/Users/gabri/Pictures/m1.jpg", Supply = new ObservableCollection<IceCream> { new IceCream(), new IceCream() } }
//};
this.ListViewProducts.ItemsSource = shopsList;
}
public MainWindow()
{
BL.BL bl = new BL.BL(Properties.Settings.Default.LibraryName);
InitializeComponent();
}
public static string BankInfo(string Bank, string Bank_Branch, string Branch_ID)
{
PMMYLoanForm Loandata = (PMMYLoanForm)HttpContext.Current.Session["Loan"];
Loandata.Bank = Bank;
Loandata.Bank_Branch = Bank_Branch;
var stringwriter = new System.IO.StringWriter();
var serializer = new XmlSerializer(Loandata.GetType());
serializer.Serialize(stringwriter, Loandata);
XmlDocument xml = new XmlDocument();
xml.LoadXml(stringwriter.ToString());
XmlNodeList nodes = xml.SelectNodes("PMMYLoanForm");
//xml.ChildNodes[0].RemoveAll();
foreach (XmlNode node in nodes)
{
//node.ParentNode.RemoveChild(node);
node.Attributes.RemoveNamedItem("xmlns:xsi");
node.Attributes.RemoveNamedItem("xmlns:xsd");
}
string strxml = xml.ChildNodes[1].OuterXml;
//string xml = "<?xml version="1.0" encoding="utf-16"?><PMMYLoanForm xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"><BusiInfo_Enterprise_Name>xgsdgsdgsdg</BusiInfo_Enterprise_Name><BusiInfo_Constitution>Partnership</BusiInfo_Constitution><BusiInfo_Curr_Address>sdgsdg</BusiInfo_Curr_Address><BusiInfo_Pincode>dgsdg</BusiInfo_Pincode><BusiInfo_State>sgsgdg</BusiInfo_State><BusiInfo_District>sdgsgsd</BusiInfo_District><BusiInfo_Location>Choose your option</BusiInfo_Location><BusiInfo_Premises>Owned</BusiInfo_Premises><BusiInfo_Mobile>sdgsdf</BusiInfo_Mobile><BusiInfo_Email>[email protected]</BusiInfo_Email><BusiInfo_Act_Existing>dfhdfh</BusiInfo_Act_Existing><BusiInfo_Act_Proposed>fhghgh</BusiInfo_Act_Proposed><BusiInfo_Commencement_Dt>10-Jun-2018</BusiInfo_Commencement_Dt><BusiInfo_IsUnitReg>Yes</BusiInfo_IsUnitReg><BusiInfo_Reg_Number>fghfhgh</BusiInfo_Reg_Number><BusiInfo_Resi_Address>hgh</BusiInfo_Resi_Address><BusiInfo_Social_Cat>Minority Community</BusiInfo_Social_Cat><BusiInfo_MonorityComm>Jains</BusiInfo_MonorityComm><Partner_Name>bvxcbvbv</Partner_Name><Partner_DOB>10-Jun-2018</Partner_DOB><Partner_Gender>Male</Partner_Gender><Partner_Resi_Address>thdf</Partner_Resi_Address><Partner_Mobile>hdfhdfh</Partner_Mobile><Partner_Qualification>dfhdfh</Partner_Qualification><Partner_Exp>dfhdfh</Partner_Exp><Partner_ID_Proof>Aadhar</Partner_ID_Proof><Partner_ID_Number>dfhdfh</Partner_ID_Number><Partner_Addr_Proof>Aadhar</Partner_Addr_Proof><Partner_AddrProof_Num>dhdfh</Partner_AddrProof_Num><Partner_PAN_DIN_Num>dfhdfh</Partner_PAN_DIN_Num><Partner_Relation>dhdfhdfh</Partner_Relation><Associate_Name>vdfdgdf</Associate_Name><Associate_Addr>dgsdgfgf</Associate_Addr><Associate_Present_Banking>dghdgdf</Associate_Present_Banking><Associate_Nature>dgdfgd</Associate_Nature><Associate_Interest>dgdf</Associate_Interest><Associate_Relation>dgdfgd</Associate_Relation><CR_Exist_SA_Banking>dfhdf</CR_Exist_SA_Banking><CR_Exist_SA_Outstanding /><CR_Exist_SA_Status>dghdfg</CR_Exist_SA_Status><CR_Exist_CA_Banking>dgdgdfgf</CR_Exist_CA_Banking><CR_Exist_CA_Outstanding>dfgdfgdf</CR_Exist_CA_Outstanding><CR_Exist_CA_Status>dfgdfgdfgd</CR_Exist_CA_Status><CR_Exist_CC_Banking>dfgdg</CR_Exist_CC_Banking><CR_Exist_CC_LimitAvailed>hjfgjf</CR_Exist_CC_LimitAvailed><CR_Exist_CC_Outstanding>sdfsfsd</CR_Exist_CC_Outstanding><CR_Exist_CC_SecurityLodg>jfgjf</CR_Exist_CC_SecurityLodg><CR_Exist_CC_Status>jdfdfjdf</CR_Exist_CC_Status><CR_Exist_TL_Banking>dfhjdfdfh</CR_Exist_TL_Banking><CR_Exist_TL_LimitAvailed>dfhdfhd</CR_Exist_TL_LimitAvailed><CR_Exist_TL_Outstanding>dhdffdfh</CR_Exist_TL_Outstanding><CR_Exist_TL_SecurityLodg>dhdfhdfh</CR_Exist_TL_SecurityLodg><CR_Exist_TL_Status>dhdfhdfh</CR_Exist_TL_Status><CR_Exist_LGBG_Banking>dhdfhd</CR_Exist_LGBG_Banking><CR_Exist_LGBG_Limit>hjghjff</CR_Exist_LGBG_Limit><CR_Exist_LGBG_Outstanding>dfdfhdh</CR_Exist_LGBG_Outstanding><CR_Exist_LGBG_SecurityLodg>dfhdfhdf</CR_Exist_LGBG_SecurityLodg><CR_Exist_LGBG_Status>dfhdfhdf</CR_Exist_LGBG_Status><CR_Prop_CC_Amount>dhdfhdfh</CR_Prop_CC_Amount><CR_Prop_CC_Purpose>dhdfhfh</CR_Prop_CC_Purpose><CR_Prop_CC_SecurityOffer>dfhdfhdf</CR_Prop_CC_SecurityOffer><CR_Prop_TL_Amount>dhdfhdfhfh</CR_Prop_TL_Amount><CR_Prop_TL_Purpose>dfhdfhdfh</CR_Prop_TL_Purpose><CR_Prop_TL_SecurityOffer>dhdfhdfhdfh</CR_Prop_TL_SecurityOffer><CR_Prop_LGBG_Amount>dhdfhdfh</CR_Prop_LGBG_Amount><CR_Prop_LGBG_Purpose>dfhdfhdf</CR_Prop_LGBG_Purpose><CR_Prop_LGBG_SecurityOffer>dfhdfhfh</CR_Prop_LGBG_SecurityOffer><CCL_WC_ActSale_previousFY>dhdhdfhdfh</CCL_WC_ActSale_previousFY><CCL_WC_ActSale_currFY>dfhdhfdfh</CCL_WC_ActSale_currFY><CCL_WC_Proj_Sale>dfhdfhdh</CCL_WC_Proj_Sale><CCL_WC_Proj_Cycle>dfhdfh</CCL_WC_Proj_Cycle><CCL_WC_Proj_Inventory>dhdfh</CCL_WC_Proj_Inventory><CCL_WC_Proj_Debtors>dfhdfh</CCL_WC_Proj_Debtors><CCL_WC_Proj_Creditors>dfhdfhd</CCL_WC_Proj_Creditors><CCL_WC_Proj_Promot_Contri>dfhdfhdfh</CCL_WC_Proj_Promot_Contri><CCL_WC_Proj_Limit>ghg</CCL_WC_Proj_Limit><CCL_TL_MachineEquip>dfhydey</CCL_TL_MachineEquip><CCL_TL_Purpose>ryerye</CCL_TL_Purpose><CCL_TL_SupplierName>cdhc</CCL_TL_SupplierName><CCL_TL_MachineCost>chdfhdfh</CCL_TL_MachineCost><CCL_TL_Promote_Contri>dfhdfhdfh</CCL_TL_Promote_Contri><CCL_TL_Loan_Req>dhdfhdf</CCL_TL_Loan_Req><CCL_TL_Repayment_Period>dhdfdf</CCL_TL_Repayment_Period><PastPerf_PYII_Act_NetSale>klhjsdkl</PastPerf_PYII_Act_NetSale><PastPerf_PYII_Act_NetProfit>kjhjkhjkh</PastPerf_PYII_Act_NetProfit><PastPerf_PYII_Act_Capital>kjhjkhjkhjk</PastPerf_PYII_Act_Capital><PastPerf_PYI_Act_NetSale>kjghkjhjkhjk</PastPerf_PYI_Act_NetSale><PastPerf_PYI_Act_NetProfit>kjhjkhjkhjkh</PastPerf_PYI_Act_NetProfit><PastPerf_PYI_Act_Capital>kjhjkhjkhjkhjkh</PastPerf_PYI_Act_Capital><PresentYear_Est_NetSale>kjghjkhjkhjkh</PresentYear_Est_NetSale><PresentYear_Est_NetProfit>kjhjkhjkhjk</PresentYear_Est_NetProfit><PresentYear_Est_Capital>kjghjkhjkhjkh</PresentYear_Est_Capital><NextYear_Proj_NetSale>kjhjkhjkhjk</NextYear_Proj_NetSale><NextYear_Proj_NetProfit>hjgfghfgh</NextYear_Proj_NetProfit><NextYear_Proj_Capital>uiytyutyu</NextYear_Proj_Capital><SatutoryObl_Reg_Shop>Yes</SatutoryObl_Reg_Shop><SatutoryObl_Reg_ShopRemark>ghgfj</SatutoryObl_Reg_ShopRemark><SatutoryObl_Reg_MSME>Yes</SatutoryObl_Reg_MSME><SatutoryObl_Reg_MSMERemark>dhdfhdfh</SatutoryObl_Reg_MSMERemark><SatutoryObl_DrugLicense>No</SatutoryObl_DrugLicense><SatutoryObl_DrugLicense_Remark>dfhdfhfh</SatutoryObl_DrugLicense_Remark><SatutoryObl_SaleReturn_File>No</SatutoryObl_SaleReturn_File><SatutoryObl_SaleReturn_File_Remark>dfhfdhdh</SatutoryObl_SaleReturn_File_Remark><SatutoryObl_ITReturn_File>Yes</SatutoryObl_ITReturn_File><SatutoryObl_ITReturn_File_Remark>dfhdfhfh</SatutoryObl_ITReturn_File_Remark><SatutoryObl_Dues_Remain>No</SatutoryObl_Dues_Remain><SatutoryObl_Dues_RemainRemark>dfhdfhfhf</SatutoryObl_Dues_RemainRemark><Bank>Select Bank</Bank><Bank_Branch>Select Branch</Bank_Branch></PMMYLoanForm>";
//string xml = "<? xml version = \"1.0\" encoding = \"utf-16\" ?>< PMMYLoanForm xmlns:xsi = \"http://www.w3.org/2001/XMLSchema-instance\" xmlns: xsd = \"http://www.w3.org/2001/XMLSchema\" >< BusiInfo_Enterprise_Name > xgsdgsdgsdg </ BusiInfo_Enterprise_Name >< BusiInfo_Constitution > Partnership </ BusiInfo_Constitution >< BusiInfo_Curr_Address > sdgsdg </ BusiInfo_Curr_Address ></ PMMYLoanForm >";
//string xml = "<?xmlversion="1.0"standalone="yes"?><Customers><CustomerId ="1"><Name>John Hammond</Name><Country>United States</Country></Customer><CustomerId = "2"><Name>Mudassar Khan</Name><Country>India</Country></Customer><CustomerId ="3"><Name>Suzanne Mathews</Name><Country>France</Country></Customer><CustomerId ="4"><Name>Robert Schidner</Name><Country>Russia</Country></Customer></Customers>";
//string xml = File.ReadAllText("C:\\Users\\Mantralaya\\Desktop\\asdf.xml");
BL.BL MOLDBAccess;
MOLDBAccess = new BL.BL(System.Configuration.ConfigurationManager.AppSettings["APPID"].ToString());
string constr = System.Configuration.ConfigurationManager.AppSettings["APPID"].ToString();
HttpContext.Current.Session["Application_ID"] = "";
try
{
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("InsertXMLFile1"))
{
cmd.Connection = con;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@xml", strxml);
SqlParameter outPutParameter = new SqlParameter();
outPutParameter.ParameterName = "@appId";
outPutParameter.SqlDbType = System.Data.SqlDbType.NVarChar;
outPutParameter.Direction = System.Data.ParameterDirection.Output;
cmd.Parameters.Add(outPutParameter);
con.Open();
int result = (int)MOLDBAccess.ExecuteNonQuery(cmd);
//cmd.ExecuteNonQuery();
string ApplID = outPutParameter.Value.ToString();
HttpContext.Current.Session["Application_ID"] = ApplID;
con.Close();
}
}
}
catch (Exception ex)
{
string ds = ex.Message + "---" + ex.StackTrace;
}
HttpContext.Current.Session["Loan"] = Loandata;
return("hello");
}
