public PartyMaster GetPartyMasterDetails(String partyID) { PartyMaster obj = null; string commandText = OleDBHelper.GetQueryText("PartyMaster_SelectID", QueryType.Procedures); OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@PartyID", partyID) }; using (DataTable table = OleDBHelper.ExecuteParamerizedSelectCommand(commandText, CommandType.Text, parameters)) { //check if any record exist or not if (table.Rows.Count > 0) { //Lets go ahead and create the list of employees obj = new PartyMaster(); obj.PartyID = Convert.ToString(table.Rows[0]["PartyID"]); obj.PartyName = Convert.ToString(table.Rows[0]["PartyName"]); obj.PersonName = Convert.ToString(table.Rows[0]["PersonName"]); obj.Address = Convert.ToString(table.Rows[0]["Address"]); obj.ContactNo = Convert.ToString(table.Rows[0]["ContactNo"]); obj.Mobile = Convert.ToString(table.Rows[0]["Mobile"]); obj.EamilAddress = Convert.ToString(table.Rows[0]["EamilAddress"]); obj.Remarks = Convert.ToString(table.Rows[0]["Remarks"]); } } return(obj); }
private void ProcessPartyMasterLookupInterface() { PartyMaster selectedParty = new PartyMaster(); frmPartyMasterLookup objLookup = new frmPartyMasterLookup(); DialogResult result; result = objLookup.ShowDialog(); if (result == DialogResult.OK) { selectedParty = objLookup.PartyMasterSelected; if (selectedParty != null) { _partyMaster = selectedParty; } FillParty(_partyMaster); } else { selectedParty = null; } objLookup.Close(); objLookup = null; }
private void FillListView() { List <PartyMaster> list = new List <PartyMaster>(); PartyMaster handler = new PartyMaster(); list = handler.GetPartyMasterList(); ListViewItem lvi = new ListViewItem(); if (list != null) { if (list.Count > 0) { foreach (PartyMaster obj in list) { lvi = new ListViewItem(obj.PartyID); lvi.SubItems.Add(obj.PartyName); lvi.SubItems.Add(obj.PersonName); lvi.SubItems.Add(obj.Address); lvi.SubItems.Add(obj.Remarks); lvi.SubItems.Add(obj.ContactNo); lvi.SubItems.Add(obj.Mobile); lvi.SubItems.Add(obj.EamilAddress); lvi.SubItems.Add(obj.Remarks); listView1.Items.Add(lvi); } } } }
public ActionResult PersonalDetails(PartyMaster umodel) { string dob = umodel.DOB.Day + "/" + umodel.DOB.Month + "/" + umodel.DOB.Year; IDbDataParameter[] Insertparam = new[] { CreateParameter(DbType.String, 100, "@MemberName", ParameterDirection.Input, (umodel.MemberName)), CreateParameter(DbType.String, 4, "@CareOfName", ParameterDirection.Input, (umodel.CareOfName)), CreateParameter(DbType.String, 10, "@Sex", ParameterDirection.Input, (umodel.Sex)), CreateParameter(DbType.String, 50, "@DOB", ParameterDirection.Input, dob), CreateParameter(DbType.String, 500, "@Address", ParameterDirection.Input, (umodel.Address)), CreateParameter(DbType.String, 50, "@City", ParameterDirection.Input, (umodel.City)), CreateParameter(DbType.String, 50, "@State", ParameterDirection.Input, (umodel.State)), CreateParameter(DbType.String, 50, "@PinCode", ParameterDirection.Input, (umodel.PinCode)), CreateParameter(DbType.String, 100, "@Phones", ParameterDirection.Input, (umodel.Phones)), CreateParameter(DbType.String, 50, "@Mobile", ParameterDirection.Input, (umodel.Mobile)), CreateParameter(DbType.String, 50, "@Email", ParameterDirection.Input, (umodel.Email)), CreateParameter(DbType.String, 50, "@MemberId", ParameterDirection.Input, (umodel.MemberId)) }; var cmd = "Update PartyMaster set MemberName='@MemberName',CareOfName='@CareOfName',Sex='@Sex',DOB=convert(datetime,'@DOB',103),Address='@Address',City='@City',State='@State',PinCode=@PinCode,Phones='@Phones',Mobile='@Mobile',Email='@Email' where MemberId='@MemberId'"; fetchdata.ExecuteQuery(cmd, Insertparam, CommandType.Text); ViewBag._DisplayMsg = "Personal Details Updated"; // var model = GetProfileById(umodel.MemberId); return(View(umodel)); }
public ActionResult Index(PartyMaster model) { var usr = GetMyProfile(); if (Request.Files.Count > 0) { if (Request.Files["UploadFile"] != null) { HttpPostedFileBase file = Request.Files["UploadFile"]; if (file.ContentLength > 0) { string value = ConfigurationManager.AppSettings["SliderPath"]; usr.Photo = Common.UploadImage(value, file, "pic_"); } } IDbDataParameter[] Insertparam = new[] { CreateParameter(DbType.String, 2000, "@Photo", ParameterDirection.Input, usr.Photo), CreateParameter(DbType.String, 50, "@Msrno", ParameterDirection.Input, gMSRNO), }; var cmd = "Update PartyMaster set Photo=@Photo where Msrno=@Msrno"; fetchdata.ExecuteQuery(cmd, Insertparam, CommandType.Text); gPic = usr.Photo; return(RedirectToAction("Index")); } return(View(model)); }
public ActionResult Register(string id = "") { PartyMaster model = new PartyMaster(); model.SponsorId = id; return(View(model)); }
public void DisplayData(string itemID = "-1") { try { if (itemID == "-1") { //New Item //Get Item code txtPartyID.Text = GlobalFunction.GetUniqueCode("PartyMaster"); } else { //Existing Item PartyMaster objHandler = new PartyMaster(); PartyMaster obj = objHandler.GetPartyMasterDetails(itemID); if (obj != null) { ClearControl(); SetItem(obj); } } } catch (Exception ex) { MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "\n" + ex.Message); } }
public PartyModel getPartyById(int id) { Mapper.CreateMap <PartyMaster, PartyModel>(); PartyMaster objComp = Dbcontext.PartyMasters.SingleOrDefault(m => m.PID == id); PartyModel objCItem = Mapper.Map <PartyModel>(objComp); return(objCItem); }
public ActionResult AssignPin(int id, string q) { PartyMaster model = new PartyMaster(); ViewBag.PinId = id; ViewBag.ETicket = q; return(View(model)); }
public PartyMaster CreatepartyMaster(PartyMaster _objCreate) { try { if (_objCreate != null) { //Check Duplicate using (LocalEntity _context = new LocalEntity()) { var party = _context.tblPartyMasters.OrderByDescending(x => x.PartyId).FirstOrDefault(); int intMaxId = 1; if (party != null) { intMaxId = party.PartyId + 1; } string strPartyCode = "Party00" + intMaxId; _context.tblPartyMasters.Add(new tblPartyMaster { PartyId = intMaxId, PartyCode = strPartyCode, ContactPerson = _objCreate.ContactPerson, Address = _objCreate.Address, Phone = _objCreate.Phone, Mobile = _objCreate.Mobile, Fax = _objCreate.Fax, Email = _objCreate.Email, Pager = _objCreate.Pager, PartyName = _objCreate.PartyName, IsActive = _objCreate.IsActive, CreatedBy = "System", CreatedOn = DateTime.Now }); if (_context.SaveChanges() == 1) { _objCreate.Code = Models.MessageCode.Success; _objCreate.MessageText = _objCreate.PartyName + " has been created successfully."; } else { _objCreate.Code = Models.MessageCode.Error; _objCreate.MessageText = "Not Created. Pleases contact administor !!"; } } } } catch (DbEntityValidationException ex) { throw ex; } catch (Exception ex) { throw ex; } return(_objCreate); }
public int Update(PartyModel model) { Mapper.CreateMap <PartyModel, PartyMaster>(); PartyMaster objVehicle = DbContext.PartyMasters.SingleOrDefault(m => m.PID == model.PID); objVehicle = Mapper.Map(model, objVehicle); DbContext.SaveChanges(); return(DbContext.SaveChanges()); }
/*Party Master : start*/ public PartyMaster SavePartyMaster(PartyMaster partymaster) { SqlParameter[] parameter; parameter = new SqlParameter[40]; parameter[0] = new SqlParameter("@Type", partymaster.Type); parameter[1] = new SqlParameter("@Name", partymaster.Name); parameter[2] = new SqlParameter("@Address1", partymaster.Address1); parameter[3] = new SqlParameter("@Address2", partymaster.Address2); parameter[4] = new SqlParameter("@Address3", partymaster.Address3); parameter[5] = new SqlParameter("@City", partymaster.City); parameter[6] = new SqlParameter("@Pincode", partymaster.Pincode); parameter[7] = new SqlParameter("@State", partymaster.State); parameter[8] = new SqlParameter("@Country", partymaster.Country); parameter[9] = new SqlParameter("@Peraddress1", partymaster.Peraddress1); parameter[10] = new SqlParameter("@Peraddress2", partymaster.Peraddress2); parameter[11] = new SqlParameter("@Peraddress3 ", partymaster.Peraddress3); parameter[12] = new SqlParameter("@Percity", partymaster.Percity); parameter[13] = new SqlParameter("@Perpincode", partymaster.Perpincode); parameter[14] = new SqlParameter("@Perstate", partymaster.Perstate); parameter[15] = new SqlParameter("@Percountry", partymaster.Percountry); parameter[16] = new SqlParameter("@Nationality", partymaster.Nationality); parameter[17] = new SqlParameter("@Residency", partymaster.Residency); parameter[18] = new SqlParameter("@Contactperson1", partymaster.Contactperson1); parameter[19] = new SqlParameter("@Tel1", partymaster.Tel1); parameter[20] = new SqlParameter("@Email1", partymaster.Email1); parameter[21] = new SqlParameter("@Contactperson2", partymaster.Contactperson2); parameter[22] = new SqlParameter("@Tel2", partymaster.Tel2); parameter[23] = new SqlParameter("@Email2", partymaster.Email2); parameter[24] = new SqlParameter("@Primaryid", partymaster.Primaryid); parameter[25] = new SqlParameter("@Panno", partymaster.Panno); parameter[26] = new SqlParameter("@Aadharno", partymaster.Aadharno); parameter[27] = new SqlParameter("@Gst", partymaster.Gst); parameter[28] = new SqlParameter("@Mobile", partymaster.Mobile); parameter[29] = new SqlParameter("@OpeningBalance", partymaster.OpeningBalance); parameter[30] = new SqlParameter("@BalancePost", partymaster.BalancePost); parameter[31] = new SqlParameter("@AddressInBill", partymaster.AddressInBill); parameter[32] = new SqlParameter("@Lock", partymaster.Lock); parameter[33] = new SqlParameter("@Category", partymaster.Category); parameter[34] = new SqlParameter("@Broker", partymaster.Broker); parameter[35] = new SqlParameter("@Location", partymaster.Location); parameter[36] = new SqlParameter("@CollectGST", partymaster.CollectGST); parameter[37] = new SqlParameter("@RBILICNo", partymaster.RBILICNo); parameter[38] = new SqlParameter("@RBIExp", partymaster.RBIExp); parameter[39] = new SqlParameter("@ControlAC", partymaster.ControlAC); DataSet dataSet = dataInterfaceSQL.GetDataSet("spInsertpartymaster", parameter, false, true); if (dataSet.Tables.Count > 0 && dataSet.Tables[0].Rows.Count > 0) { partymaster.Id = Convert.ToInt32(dataSet.Tables[0].Rows[0]["Id"]); } return(partymaster); }
private void SetItem(PartyMaster obj) { txtPartyID.Text = obj.PartyID; txtPartyName.Text = obj.PartyName; txtPersonName.Text = obj.PersonName; txtAddress.Text = obj.Address; txtContactNo.Text = obj.ContactNo; txtMobile.Text = obj.Mobile; txtEmail.Text = obj.EamilAddress; txtRemarks.Text = obj.Remarks; }
public ActionResult PersonalDetails(string id = "") { if (gRole == "USER") { id = gMemberId; } var model = new PartyMaster(); model = GetProfileById(id); return(View(model)); }
private void cmdPartyLookup_Click(object sender, EventArgs e) { PartyMaster partyMaster = (PartyMaster)GlobalFunction.ShowLookUpForm("frmPartyMaster"); if (partyMaster != null) { PartyID = partyMaster.PartyID; txtPartyName.Text = partyMaster.PartyName; txtContactNo.Text = partyMaster.ContactNo; txtAddress.Text = partyMaster.Address; } }
public ActionResult Register(PartyMaster model) { if (!CheckSponserId(model.SponsorId)) { ViewBag.DisplayClass = "text-red"; ViewBag._DisplayMsg = "Please enter a valid SponsorId"; return(View(model)); } // IDbDataParameter[] param = new[] //{ // CreateParameter(DbType.String, 50, "@PanNo", ParameterDirection.InputOutput,model.PanNo), // }; // string cmd = "Select * from PartyMaster where PanNo=@PanNo"; // ds = fetchdata.GetDataSet(cmd, param, CommandType.Text); // if (ds.Tables.Count > 0) // { // var dt = ds.Tables[0]; // var PartyMasterlist = CommonMethod.ConvertToList<PartyMaster>(dt).FirstOrDefault(); // if (PartyMasterlist == null) // { var UnigueUrl = Guid.NewGuid().ToString().Replace("-", ""); var OTP = CreateEPin(7); IDbDataParameter[] Insertparam = new[] { CreateParameter(DbType.String, 50, "@SponsorId", ParameterDirection.Input, model.SponsorId), CreateParameter(DbType.String, 100, "@SponsorName", ParameterDirection.Input, model.SponsorName), CreateParameter(DbType.String, 100, "@MemberName", ParameterDirection.Input, model.MemberName), CreateParameter(DbType.String, 10, "@Sex", ParameterDirection.Input, model.Sex), CreateParameter(DbType.String, 50, "@PanNo", ParameterDirection.Input, ""), CreateParameter(DbType.String, 50, "@Mobile", ParameterDirection.Input, model.Mobile), CreateParameter(DbType.String, 50, "@Email", ParameterDirection.Input, model.Email), CreateParameter(DbType.String, 50, "@Password", ParameterDirection.Input, model.Password), CreateParameter(DbType.String, 500, "@UnigueUrl", ParameterDirection.Input, UnigueUrl), CreateParameter(DbType.String, 50, "@OTP", ParameterDirection.Input, OTP), CreateParameter(DbType.String, 50, "@OUTMemberID", ParameterDirection.Output, ""), }; string cmd = "spInsertMember"; var memberid = fetchdata.ExecuteQuerySP(cmd, Insertparam, CommandType.StoredProcedure); var name = model.MemberName + " Your MemberId is " + memberid; //SendOTP(model.Mobile, OTP,name); SendWelcomeMsg(model.Mobile, model.MemberName, memberid, model.Password); //return RedirectToAction("VerifyMobile",new {id= memberid }); // } //} ViewBag.DisplayClass = "text-green"; ViewBag._DisplayMsg = "Your account has been created. You can login to your account Now."; model = new PartyMaster(); return(View(model)); }
public bool UpdateParty(PartyMaster partyMaster) { try { _context.Update(partyMaster); _context.SaveChanges(); return(true); } catch (Exception ex) { return(false); } }
public int UpdatePartyMaster(PartyMaster partymaster) { SqlParameter[] parameter = new SqlParameter[42]; parameter[0] = new SqlParameter("@Type", partymaster.Type); parameter[1] = new SqlParameter("@Name", partymaster.Name); parameter[2] = new SqlParameter("@Address1", partymaster.Address1); parameter[3] = new SqlParameter("@Address2", partymaster.Address2); parameter[4] = new SqlParameter("@Address3", partymaster.Address3); parameter[5] = new SqlParameter("@City", partymaster.City); parameter[6] = new SqlParameter("@Pincode", partymaster.Pincode); parameter[7] = new SqlParameter("@State", partymaster.State); parameter[8] = new SqlParameter("@Country", partymaster.Country); parameter[9] = new SqlParameter("@Peraddress1", partymaster.Peraddress1); parameter[10] = new SqlParameter("@Peraddress2", partymaster.Peraddress2); parameter[11] = new SqlParameter("@Peraddress3 ", partymaster.Peraddress3); parameter[12] = new SqlParameter("@Percity", partymaster.Percity); parameter[13] = new SqlParameter("@Perpincode", partymaster.Perpincode); parameter[14] = new SqlParameter("@Perstate", partymaster.Perstate); parameter[15] = new SqlParameter("@Percountry", partymaster.Percountry); parameter[16] = new SqlParameter("@Nationality", partymaster.Nationality); parameter[17] = new SqlParameter("@Residency", partymaster.Residency); parameter[18] = new SqlParameter("@Contactperson1", partymaster.Contactperson1); parameter[19] = new SqlParameter("@Tel1", partymaster.Tel1); parameter[20] = new SqlParameter("@Email1", partymaster.Email1); parameter[21] = new SqlParameter("@Contactperson2", partymaster.Contactperson2); parameter[22] = new SqlParameter("@Tel2", partymaster.Tel2); parameter[23] = new SqlParameter("@Email2", partymaster.Email2); parameter[24] = new SqlParameter("@Primaryid", partymaster.Primaryid); parameter[25] = new SqlParameter("@Panno", partymaster.Panno); parameter[26] = new SqlParameter("@Aadharno", partymaster.Aadharno); parameter[27] = new SqlParameter("@Gst", partymaster.Gst); parameter[28] = new SqlParameter("@Mobile", partymaster.Mobile); parameter[29] = new SqlParameter("@OpeningBalance", partymaster.OpeningBalance); parameter[30] = new SqlParameter("@BalancePost", partymaster.BalancePost); parameter[31] = new SqlParameter("@AddressInBill", partymaster.AddressInBill); parameter[32] = new SqlParameter("@Lock", partymaster.Lock); parameter[33] = new SqlParameter("@Category", partymaster.Category); parameter[34] = new SqlParameter("@Broker", partymaster.Broker); parameter[35] = new SqlParameter("@Location", partymaster.Location); parameter[36] = new SqlParameter("@CollectGST", partymaster.CollectGST); parameter[37] = new SqlParameter("@RBILICNo", partymaster.RBILICNo); parameter[38] = new SqlParameter("@RBIExp", partymaster.RBIExp); parameter[39] = new SqlParameter("@ControlAC", partymaster.ControlAC); parameter[40] = new SqlParameter("@Id", partymaster.Id); parameter[41] = new SqlParameter("@IsDeleted", partymaster.IsDeleted); int i = dataInterfaceSQL.ExecuteNonQueryDB("spUpdatePartyMaster", parameter); return(i); }
private void FillParty(PartyMaster obj) { string newLine = Environment.NewLine; if (obj != null) { txtPartyName.Text = obj.PartyName; txtAddress.Text = obj.Address + newLine + "Phone: " + obj.ContactNo ?? ""; txtContactNo.Text = obj.PersonName + newLine + "Mobile" + obj.Mobile ?? "" + "Email" + obj.EamilAddress ?? ""; } }
private PartyMaster GetMyProfile() { var model = new PartyMaster(); string cmd = "Select * from PartyMaster where Msrno=" + gMSRNO; ds = fetchdata.GetDataSet(cmd); DataTable dt = new DataTable(); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; model = CommonMethod.ConvertToList <PartyMaster>(dt).FirstOrDefault(); } return(model); }
private PartyMaster GetProfileById(string id = "") { var model = new PartyMaster(); string cmd = "Select * from PartyMaster where MemberId='" + id + "'"; ds = fetchdata.GetDataSet(cmd); DataTable dt = new DataTable(); if (ds.Tables.Count > 0) { dt = ds.Tables[0]; model = CommonMethod.ConvertToList <PartyMaster>(dt).FirstOrDefault(); } return(model); }
private PartyMaster GetItem() { PartyMaster obj = new PartyMaster(); obj.PartyID = txtPartyID.Text; obj.PartyName = txtPartyName.Text; obj.PersonName = txtPersonName.Text; obj.Address = txtAddress.Text; obj.ContactNo = txtContactNo.Text; obj.Mobile = txtMobile.Text; obj.EamilAddress = txtEmail.Text; obj.Remarks = txtRemarks.Text; return(obj); }
public override string Execute(string original) { original = original.Replace("${Gs2::Weave::FormationNamespaceName}", _installer.formationNamespaceName); original = original.Replace("${Gs2::Weave::MoldModelName}", _installer.moldModelName); original = original.Replace("${Gs2::Weave::FormModelName}", _installer.formModelName); original = original.Replace("${Gs2::Weave::PartyKeyNamespaceName}", _installer.keyNamespaceName); original = original.Replace("${Gs2::Weave::PartyKeyName}", _installer.keyName); original = original.Replace("${Gs2::Weave::NumberOfSaveArea}", _installer.numberOfSaveArea.ToString()); original = original.Replace("${Gs2::Weave::NumberOfUnit}", _installer.numberOfUnit.ToString()); { var slots = new List <SlotModel>(); for (var i = 0; i < _installer.numberOfUnit; i++) { slots.Add(new SlotModel { name = i.ToString(), }); } var master = new PartyMaster { moldModels = new List <MoldModel> { new MoldModel { name = _installer.moldModelName, initialMaxCapacity = _installer.numberOfSaveArea, maxCapacity = _installer.numberOfSaveArea, formModel = new FormModel { name = _installer.formModelName, slots = slots, }, } } }; var stringBuilder = new StringBuilder(); var jsonWriter = new JsonWriter(stringBuilder); master.WriteJson(jsonWriter); var json = JsonMapper.ToObject(original); json["Resources"]["FormationSettings"]["Properties"]["Settings"] = stringBuilder.ToString(); original = json.ToJson(); } return(original); }
public void AddOrderWithParty(OrderMaster orderMaster, PartyMaster partyMaster, UserAddress userAddress) { _context.Add(partyMaster); _context.SaveChanges(); if (partyMaster.Id > 0) { userAddress.PartyId = partyMaster.Id; _context.Add(userAddress); _context.SaveChanges(); orderMaster.PartyId = partyMaster.Id; _context.Add(orderMaster); _context.SaveChanges(); } }
public ActionResult Register(PartyMaster model) { if (!CheckSponserId(model.SponsorId)) { ViewBag._DisplayMsg = "Please enter a valid SponsorId"; return(View(model)); } IDbDataParameter[] param = new[] { CreateParameter(DbType.String, 50, "@PanNo", ParameterDirection.InputOutput, model.PanNo), }; string cmd = "Select * from PartyMaster where PanNo=@PanNo"; ds = fetchdata.GetDataSet(cmd, param, CommandType.Text); if (ds.Tables.Count > 0) { var dt = ds.Tables[0]; var PartyMasterlist = CommonMethod.ConvertToList <PartyMaster>(dt).FirstOrDefault(); if (PartyMasterlist == null) { var UnigueUrl = Guid.NewGuid().ToString().Replace("-", ""); var OTP = CreateEPin(7); IDbDataParameter[] Insertparam = new[] { CreateParameter(DbType.String, 50, "@SponsorId", ParameterDirection.Input, model.SponsorId), CreateParameter(DbType.String, 100, "@SponsorName", ParameterDirection.Input, model.SponsorName), CreateParameter(DbType.String, 100, "@MemberName", ParameterDirection.Input, model.MemberName), CreateParameter(DbType.String, 10, "@Sex", ParameterDirection.Input, model.Sex), CreateParameter(DbType.String, 50, "@PanNo", ParameterDirection.Input, model.PanNo), CreateParameter(DbType.String, 50, "@Mobile", ParameterDirection.Input, model.Mobile), CreateParameter(DbType.String, 50, "@Email", ParameterDirection.Input, model.Email), CreateParameter(DbType.String, 50, "@Password", ParameterDirection.Input, model.Password), CreateParameter(DbType.String, 500, "@UnigueUrl", ParameterDirection.Input, UnigueUrl), CreateParameter(DbType.String, 50, "@OTP", ParameterDirection.Input, OTP), CreateParameter(DbType.String, 50, "@OUTMemberID", ParameterDirection.Output, ""), }; cmd = "spInsertMember"; var memberid = fetchdata.ExecuteQuerySP(cmd, Insertparam, CommandType.StoredProcedure); SendWelcomeMsg(model.Mobile, model.MemberName, memberid, model.Password); return(RedirectToAction("Index")); } } ViewBag._DisplayMsg = "Please use different Pan number, this is already used"; return(View(model)); }
public ActionResult AssignPin(int id, string q, string memberid, PartyMaster umodel, string btn = "") { if (btn == "Assign Pin") { SqlTransaction trans = fetchdata.GetTrans(); IDbDataParameter[] param = new[] { CreateParameter(DbType.String, 50, "@MemberId", ParameterDirection.Input, umodel.MemberId), CreateParameter(DbType.String, 50, "@ETicket", ParameterDirection.Input, q), }; string cmd = "Update PartyMaster set ETicket=@ETicket where MemberId=@MemberId"; fetchdata.ExecuteQuery(cmd, param, trans, CommandType.Text); IDbDataParameter[] eparam = new[] { CreateParameter(DbType.Int32, 50, "@PinId", ParameterDirection.Input, id), CreateParameter(DbType.String, 50, "@ETicket", ParameterDirection.Input, q), }; cmd = "Update eTicket set IsUsed=1 where PinId=@PinId"; fetchdata.ExecuteQuery(cmd, eparam, trans, CommandType.Text); IDbDataParameter[] insertparam = new[] { CreateParameter(DbType.String, 50, "@MemberID", ParameterDirection.Input, umodel.MemberId), CreateParameter(DbType.Int32, 50, "@Msrno", ParameterDirection.Input, umodel.Msrno), CreateParameter(DbType.Int32, 50, "@ETicketId", ParameterDirection.Input, id), CreateParameter(DbType.DateTime, 50, "@Paiddt", ParameterDirection.Input, DateTime.Now), }; string ncmd = "insert into GreenDetail(Msrno,MemberID,ETicketId,Paiddt) values(@Msrno,@MemberID,@ETicketId,@Paiddt)"; fetchdata.ExecuteQuery(ncmd, insertparam, trans, CommandType.Text); trans.Commit(); return(RedirectToAction("Index")); } else { PartyMaster model = GetProfileById(memberid); ViewBag.PinId = id; ViewBag.ETicket = q; return(View(model)); } }
public JsonResult EditPartiesMaster(PartyMaster partymaster) { try { if (ModelState.IsValid) { MasterQueries masterQueries = new MasterQueries(); int res = masterQueries.UpdatePartyMaster(partymaster); int i = masterQueries.SaveAdditionalData(partymaster.AdditionalData, (partymaster.Id.ToString())); return(Json(Functions.OutPutResponse(true, "Data Updated Succfully", partymaster))); } } catch (Exception ex) { return(Json(Functions.OutPutResponse(false, ex.Message))); } return(null); }
public bool AddNewPartyMaster(PartyMaster obj) { OleDbParameter[] parameters = new OleDbParameter[] { new OleDbParameter("@PartyID", obj.PartyID), new OleDbParameter("@PartyName", obj.PartyName), new OleDbParameter("@PersonName", obj.PersonName), new OleDbParameter("@Address", obj.Address), new OleDbParameter("@ContactNo", obj.ContactNo), new OleDbParameter("@Mobile", obj.Mobile), new OleDbParameter("@EamilAddress", obj.EamilAddress), new OleDbParameter("@Remarks", obj.Remarks), new OleDbParameter("@CreatedOn", GlobalFunction.GetDateTimeWithoutMiliSecond(DateTime.Now)) }; string commandText = OleDBHelper.GetQueryText("PartyMaster_Insert", QueryType.Procedures); return(OleDBHelper.ExecuteNonQuery(commandText, CommandType.Text, parameters)); }
public ActionResult BankDetails(PartyMaster umodel) { IDbDataParameter[] Insertparam = new[] { CreateParameter(DbType.String, 50, "@AcNo", ParameterDirection.Input, umodel.AcNo), CreateParameter(DbType.String, 200, "@BankName", ParameterDirection.Input, umodel.BankName), CreateParameter(DbType.String, 50, "@BranchName", ParameterDirection.Input, umodel.BranchName), CreateParameter(DbType.String, 200, "@ISFC", ParameterDirection.Input, umodel.ISFC), CreateParameter(DbType.String, 50, "@AadharNo", ParameterDirection.Input, umodel.AadharNo), CreateParameter(DbType.String, 50, "@PanNo", ParameterDirection.Input, umodel.PanNo), CreateParameter(DbType.String, 50, "@MemberId", ParameterDirection.Input, umodel.MemberId), }; var cmd = "Update PartyMaster set AcNo=@AcNo,BankName=@BankName,BranchName=@BranchName,ISFC=@ISFC,AadharNo=@AadharNo,PanNo=@PanNo where MemberId=@MemberId"; fetchdata.ExecuteQuery(cmd, Insertparam, CommandType.Text); ViewBag._DisplayMsg = "Bank Details Updated"; //var model = GetProfileById(umodel.MemberId); return(View(umodel)); }
private void ProcessLookUpOK() { PartyMasterSelected = new PartyMaster(); int selectedIndex = dgvMain.SelectedRows[0].Index; if (selectedIndex != -1) { PartyMasterSelected.PartyID = Convert.ToString(dgvMain.Rows[selectedIndex].Cells[PartyIDIndex].Value); PartyMasterSelected.PartyName = Convert.ToString(dgvMain.Rows[selectedIndex].Cells[PartyNameIndex].Value); PartyMasterSelected.PersonName = Convert.ToString(dgvMain.Rows[selectedIndex].Cells[PersonNameIndex].Value); PartyMasterSelected.Address = Convert.ToString(dgvMain.Rows[selectedIndex].Cells[AddressIndex].Value); } else { PartyMasterSelected = null; } this.DialogResult = DialogResult.OK; }