public IHttpActionResult KaziLogin(int NID, string Password) { MarriageRegistrationDBEntities db = new MarriageRegistrationDBEntities(); int aa = NID; string pass = Password; var kazi = db.Kazis.SingleOrDefault(m => m.NID == aa && m.Password == pass); if (kazi != null) { var id = kazi.Id; return(Ok(id)); //return Ok(kazi); } return(NotFound()); }
// POST: api/MarriageRegisters public IHttpActionResult Post([FromBody] MarrigeRegisterView value) { MarriageRegistrationDBEntities db = new MarriageRegistrationDBEntities(); var witnes = new Witness(); witnes.Witness1 = value.Witness1Name; witnes.Witness2 = value.Witness2Name; witnes.Witness3 = value.Witness3Name; db.Witnesses.Add(witnes); //db.SaveChanges(); var attorney = new Attorney(); attorney.BrideAttorneyName = value.BridegroomAttorneyName; attorney.BridegroomAttorneyNID = value.BridegroomAttorneyNID; attorney.BrideAttorneyName = value.BrideAttorneyName; attorney.BrideAttorneyNID = value.BrideAttorneyNID; db.Attorneys.Add(attorney); //db.SaveChanges(); var ff = Guid.NewGuid().ToString(); var now = DateTime.Now; var year = now.Year; var month = now.Month.ToString("00"); var date = now.Day.ToString("00"); var fomat = year + month + date; var maxId = 0; if (db.MarriageRegisters.Any(m => m.MarriageRegiNo.StartsWith(fomat))) { maxId = db.MarriageRegisters .Where(m => m.MarriageRegiNo.StartsWith(fomat)) .Select(m => m.MarriageRegiNo.Substring(fomat.Length)) .Select(int.Parse) .Max() + 1; } var id = fomat + (maxId.ToString().PadLeft(5, '0')); var marriageRegister = new MarriageRegister(); marriageRegister.BrideName = value.BrideName; marriageRegister.BrideNID = value.BrideNID; marriageRegister.BridegroomName = value.BridegroomName; marriageRegister.BridegroomNID = value.BridegroomNID; marriageRegister.MarriageRegiNo = id; marriageRegister.Mohor = value.Mohor; marriageRegister.Moajjal = value.Moajjal; marriageRegister.NonMoajjal = value.NonMoajjal; marriageRegister.NikhaReaderName = value.NikhaReaderName; marriageRegister.NikhaReaderNameNID = value.NikhaReaderNameNID; marriageRegister.WitnessId = witnes.Id; marriageRegister.AttorneyId = attorney.Id; marriageRegister.kaziId = value.KaziId; marriageRegister.Date = DateTime.Now; marriageRegister.PaidAmount = value.PaidAmount; db.MarriageRegisters.Add(marriageRegister); db.SaveChanges(); return(Ok(marriageRegister.MarriageRegiNo)); }