public static int FetchOrCreateMaritalStatus(CMSDataContext Db, string type) { var ms = Db.MaritalStatuses.SingleOrDefault(m => m.Description == type); if (ms == null) { var max = Db.BaptismTypes.Max(mm => mm.Id) + 10; ms = new MaritalStatus() { Id = max, Code = "ms" + max, Description = type }; Db.MaritalStatuses.InsertOnSubmit(ms); Db.SubmitChanges(); } return ms.Id; }
public static int FetchOrCreateMaritalStatusId(CMSDataContext db, string status) { var ms = db.MaritalStatuses.SingleOrDefault(m => m.Description == status); if (ms == null) { var max = db.MaritalStatuses.Max(mm => mm.Id) + 1; ms = new MaritalStatus() { Id = max, Code = "M" + max, Description = status }; db.MaritalStatuses.InsertOnSubmit(ms); db.SubmitChanges(); } return ms.Id; }