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