public AlKhairService() { _uow = new BDMDataUoWork(DBHelper.ConnectionString); _giftTypeVwRepo = new EFRepository<GiftTypeView>(_uow); _vchRepo = new EFRepository<VoucherBE>(_uow); _vchNoRepo = new EFRepository<VoucherNoBE>(_uow); _bdmSvc = new BDMService(); }
public int AddGiftType(GiftTypeBE mod) { EntityDE ety = new EntityDE(); ety.SiteCode = mod.SiteCode; ety.EntityTypeCode = mod.EntityTypeCode; ety.EntityName = mod.EntityName; ety.Code = mod.Code; int retVal = 0; SqlConnection con = new SqlConnection(DBHelper.ConnectionString); try { _bdmSvc = new BDMService(); StringBuilder sb = new StringBuilder(); using (TransactionScope trans = new TransactionScope()) { mod.ID = _bdmSvc.AddEntity(ety); SqlCommand cmd = new SqlCommand(); #region CommandText & Params sb.Append("INSERT INTO [dbo].[GiftType]"); sb.Append("([GiftTypeID]"); sb.Append(",[IsCondition]"); sb.Append(",[Price])"); sb.Append("VALUES"); sb.Append("(@GiftTypeID"); sb.Append(",@IsCondition"); sb.Append(",@Price)"); cmd.Parameters.AddWithValue("@GiftTypeID", mod.ID); cmd.Parameters.AddWithValue("@IsCondition", mod.IsCondition); cmd.Parameters.AddWithValue("@Price", mod.Price); #endregion cmd.Connection = con; cmd.CommandText = sb.ToString(); con.Open(); cmd.ExecuteNonQuery(); retVal = mod.ID; trans.Complete(); } } catch (Exception ex) { retVal = -1; } finally { con.Close(); } return retVal; }
public void ModifyEntity() { _bdmSvc = new BDMService(); List<EntityDE> entities = _bdmSvc.GetAllEntities(AppConstants.SITE_CODE); var ety = entities.LastOrDefault(); ety.EntityName = "Imran Farooq ..."; ety.EntityTypeCode = EntityTypes.DOC.ToString(); ety.SiteCode = AppConstants.SITE_CODE; AddressDE add = ety.Addresses.FirstOrDefault(); add.AddressLine1 = "St. Ahmad Din Sipahi ..."; add.AddressLine2 = "Moh. Fatu Pura, Gujrat .."; ContactDE contact = ety.Contacts.FirstOrDefault(); contact.Mobile1 = "0333-348343499 ..."; _bdmSvc.ModifyEntity(ety); ety = _bdmSvc.GetEntityById(AppConstants.SITE_CODE, ety.ID); }
//[TestMethod] public void AddEntity() { _bdmSvc = new BDMService(); EntityDE ety = new EntityDE(); ety.EntityName = "Imran Farooq"; ety.EntityTypeCode = EntityTypes.MGR.ToString(); ety.SiteCode = AppConstants.SITE_CODE; AddressDE add = new AddressDE(AddressTypes.Personal.ToString()); add.AddressLine1 = "St. Ahmad Din Sipahi"; add.AddressLine2 = "Moh. Fatu Pura, Gujrat"; ContactDE contact = new ContactDE(); contact.Mobile1 = "0333-348343499"; ety.Addresses.Add(add); ety.Contacts.Add(contact); decimal retVal = _bdmSvc.AddEntity(ety); }
public GroceryKitController() { _bdmSvc = new BDMService(); _grocerySvc = new GroceryKitService(); }
public int AddMember(MemberDE mod) { int Id = 0; SqlConnection con = new SqlConnection(DBHelper.ConnectionString); StringBuilder sb = new StringBuilder(); bool entityAddFlag = false; using (TransactionScope trans = new TransactionScope()) { _bdmSvc = new BDMService(); Person p = mod.ToPerson(); Id = _bdmSvc.AddPerson(p); #region Commented Code //#region Add Entity //SqlCommand cmd = new SqlCommand(); //#region CommandText & Params //sb.Append("INSERT INTO [dbo].[Entity]"); //sb.Append("([SiteCode]"); //sb.Append(",[EntityTypeCode]"); ////sb.Append(",[ParentEntityID]"); //sb.Append(",[EntityName]"); //sb.Append(",[IsActive])"); //sb.Append("VALUES"); //sb.Append("(@SiteCode"); //sb.Append(",@EntityTypeCode"); ////sb.Append(",@ParentEntityID"); //sb.Append(",@EntityName"); //sb.Append(",@IsActive)"); //sb.Append("Select @@IDENTITY"); ////sb.Append("GO"); //cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode); //cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode); ////cmd.Parameters.AddWithValue("@ParentEntityID", mod.Person.ParentEntityID); //cmd.Parameters.AddWithValue("@EntityName", mod.EntityName); //cmd.Parameters.AddWithValue("@IsActive", mod.IsActive); //#endregion //cmd.Connection = con; //cmd.CommandText = sb.ToString(); //con.Open(); //try //{ // decimal val = decimal.Zero; // object retVal = cmd.ExecuteScalar(); // if (retVal != null) // { // val = (decimal)retVal; // Id = Convert.ToInt32(val); // } //} //catch (Exception ex) //{ //} //#endregion //#region Add Person //cmd = new SqlCommand(); //#region CommandText & Params //sb = new StringBuilder(); //sb.Append("INSERT INTO [dbo].[Person]"); // sb.Append("([SiteCode]"); // sb.Append(",[EntityTypeCode]"); // sb.Append(",[PersonId]"); // sb.Append(",[ParentId]"); // sb.Append(",[ParentRelationId]"); // sb.Append(",[MeritalStatusId]"); // //sb.Append(",[Occupation]"); // sb.Append(",[DOB]"); // sb.Append(",[Age]"); // sb.Append(",[Picture]"); // sb.Append(",[Gender]"); // sb.Append(",[Signature]"); // sb.Append(",[ThumbImpression]"); // sb.Append(",[NationalId])"); //sb.Append("VALUES"); // sb.Append("(@SiteCode"); // sb.Append(",@EntityTypeCode"); // sb.Append(",@PersonId"); // sb.Append(",@ParentId"); // sb.Append(",@ParentRelationId"); // sb.Append(",@MeritalStatusId"); // //sb.Append(",@Occupation"); // sb.Append(",@DOB"); // sb.Append(",@Age"); // sb.Append(",@Picture"); // sb.Append(",@Gender"); // sb.Append(",@Signature"); // sb.Append(",@ThumbImpression"); // sb.Append(",@NationalId)"); // //sb.Append("GO"); // cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode); // cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode); // cmd.Parameters.AddWithValue("@PersonId", Id); // cmd.Parameters.AddWithValue("@ParentId", mod.ParentId); // cmd.Parameters.AddWithValue("@ParentRelationId", mod.ParentRelationId); // cmd.Parameters.AddWithValue("@MeritalStatusID", mod.MeritalStatuId); // //cmd.Parameters.AddWithValue("@Occupation", mod.Occupation); // cmd.Parameters.AddWithValue("@DOB", mod.DOB); // cmd.Parameters.AddWithValue("@Age", mod.Age); // cmd.Parameters.AddWithValue("@Picture", mod.Picture); // cmd.Parameters.AddWithValue("@Gender", mod.Gender); // cmd.Parameters.AddWithValue("@Signature", mod.Signature); // cmd.Parameters.AddWithValue("@ThumbImpression", mod.ThumbImpression); // cmd.Parameters.AddWithValue("@NationalId", mod.NationalId); //#endregion //cmd.CommandText = sb.ToString(); //cmd.Connection = con; //try //{ // cmd.ExecuteNonQuery(); //} //catch (Exception ex) //{ //} //#endregion #endregion #region Add Form SqlCommand cmd = new SqlCommand(); #region CommandText & Params sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Form]"); sb.Append("([SiteCode]"); sb.Append(",[EntityTypeCode]"); sb.Append(",[FormId]"); sb.Append(",[FormNo]"); sb.Append(",[FormType]"); sb.Append(",[FatherOrHusbandName]"); sb.Append(",[MedicalProblemId]"); sb.Append(",[MemberStatusId]"); sb.Append(",[OccupationId]"); sb.Append(",[HouseStatus]"); sb.Append(",[ZakatAcceptable]"); sb.Append(",[FamilySize]"); sb.Append(",[Salary]"); sb.Append(",[Donations]"); sb.Append(",[OtherIncome]"); sb.Append(",[ShortfallInCash]"); sb.Append(",[Remarks]"); sb.Append(",[IsDeserving]"); sb.Append(",[ReferredBy]"); sb.Append(",[DataCollectedBy]"); sb.Append(",[DataCollectedBySign]"); sb.Append(",[ApprovalByDataCollectedPerson]"); sb.Append(",[AuthorizedBy]"); sb.Append(",[ApprovalByDataAuthorizedPerson])"); sb.Append("VALUES"); sb.Append("(@SiteCode"); sb.Append(",@EntityTypeCode"); sb.Append(",@FormId"); sb.Append(",@FormNo"); sb.Append(",@FormType"); sb.Append(",@FatherOrHusbandName"); sb.Append(",@MedicalProblemId"); sb.Append(",@MemberStatusId"); sb.Append(",@OccupationId"); sb.Append(",@HouseStatus"); sb.Append(",@ZakatAcceptable"); sb.Append(",@FamilySize"); sb.Append(",@Salary"); sb.Append(",@Donations"); sb.Append(",@OtherIncome"); sb.Append(",@ShortfallInCash"); sb.Append(",@Remarks"); sb.Append(",@IsDeserving"); sb.Append(",@ReferredBy"); sb.Append(",@DataCollectedBy"); sb.Append(",@DataCollectedBySign"); sb.Append(",@ApprovalByDataCollectedPerson"); sb.Append(",@AuthorizedBy"); sb.Append(",@ApprovalByDataAuthorizedPerson)"); cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode); cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode); cmd.Parameters.AddWithValue("@FormId", Id); cmd.Parameters.AddWithValue("@FormNo", mod.FormNo); cmd.Parameters.AddWithValue("@FormType", mod.FormType); cmd.Parameters.AddWithValue("@FatherOrHusbandName", mod.FatherOrHusbandName); cmd.Parameters.AddWithValue("@MedicalProblemId", mod.MedicalProblemId); cmd.Parameters.AddWithValue("@MemberStatusId", mod.MemberStatusId); cmd.Parameters.AddWithValue("@OccupationId", mod.OccupationId); cmd.Parameters.AddWithValue("@HouseStatus", mod.HouseStatus); cmd.Parameters.AddWithValue("@ZakatAcceptable", mod.ZakatAcceptable); cmd.Parameters.AddWithValue("@FamilySize", mod.FamilySize); cmd.Parameters.AddWithValue("@Salary", mod.Salary); cmd.Parameters.AddWithValue("@Donations", mod.Donations); cmd.Parameters.AddWithValue("@OtherIncome", mod.OtherIncome); cmd.Parameters.AddWithValue("@ShortfallInCash", mod.ShortFallInCash); cmd.Parameters.AddWithValue("@Remarks", mod.Remarks); cmd.Parameters.AddWithValue("@IsDeserving", mod.IsDeserving); cmd.Parameters.AddWithValue("@ReferredBy", mod.ReferredBy); cmd.Parameters.AddWithValue("@DataCollectedBy", mod.DataCollectedBy); cmd.Parameters.AddWithValue("@DataCollectedBySign", mod.DataCollectedBySignatures); cmd.Parameters.AddWithValue("@ApprovalByDataCollectedPerson", mod.ApprovalByDataCollectedPerson); cmd.Parameters.AddWithValue("@AuthorizedBy", mod.AuthorizedBy); cmd.Parameters.AddWithValue("@ApprovalByDataAuthorizedPerson", mod.ApprovalByDataAuthorizedPerson); #endregion cmd.CommandText = sb.ToString(); cmd.Connection = con; try { cmd.ExecuteNonQuery(); } catch (Exception Ex) { } #endregion #region Member cmd = new SqlCommand(); sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Member]"); sb.Append("([SiteCode]"); sb.Append(",[EntityTypeCode]"); sb.Append(",[MemberId]"); sb.Append(",[RegDate]"); sb.Append(",[RegNo]"); sb.Append(",[DistributionPointId]"); sb.Append(",[FamilyPackageId]"); sb.Append(",[IsActive])"); sb.Append("VALUES"); sb.Append("(@SiteCode"); sb.Append(",@EntityTypeCode"); sb.Append(",@MemberId"); sb.Append(",@RegDate"); sb.Append(",@RegNo"); sb.Append(",@DistributionPointId"); sb.Append(",@FamilyPackageId"); sb.Append(",@IsActive)"); //sb.Append("GO"); cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode); cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode); cmd.Parameters.AddWithValue("@MemberId", Id); cmd.Parameters.AddWithValue("@RegDate", mod.RegDate); cmd.Parameters.AddWithValue("@RegNo", mod.RegNo); cmd.Parameters.AddWithValue("@DistributionPointId", mod.DistributionPointId); cmd.Parameters.AddWithValue("@FamilyPackageId", mod.FamilyPackageId); cmd.Parameters.AddWithValue("@IsActive", mod.IsActive); #endregion cmd.CommandText = sb.ToString(); cmd.Connection = con; try { cmd.ExecuteNonQuery(); } catch (Exception ex) { } con.Close(); trans.Complete(); } return Id; }
public BDM() { _bdmSvc = new BDMService(); }
public void Person_View() { _bdmSvc = new BDMService(); var list = _bdmSvc.GetViewOfAllPersons("QST"); }
public void Person_CRUD() { _bdmSvc = new BDMService(); Person p = new Person(); //p.SiteCode = "QST"; //p.EntityName = "Imran"; //p.EntityTypeCode = "DNR"; //var mod = _bdmSvc.AddPerson(p); var list = _bdmSvc.GetViewOfAllPersons("QST"); if (list != null && list.Count > 0) { PersonView pv = list[0]; //p = pv.ToPerson(); //p.EntityName = "Imran ..."; //p.Signature = "imran@123"; //if (_bdmSvc.ModifyPerson(p)) //{ //} p = _bdmSvc.GetPersonById(pv.SiteCode, pv.EntityTypeCode, pv.ID); } }
public void Entity_CRUD() { EntityDE ety = new EntityDE(); ety.SiteCode = "QST"; ety.EntityTypeCode = "DNR"; ety.EntityName = "Khairaat"; ety.Code = "090"; _bdmSvc = new BDMService(); int id = _bdmSvc.AddEntity(ety); ety.ID = id; ety.EntityName = "Khariraat ..."; bool res = _bdmSvc.ModifyEntity(ety); res = _bdmSvc.DeleteEntity(ety.SiteCode, ety.EntityTypeCode, ety.ID); }
public void EntityView() { _bdmSvc = new BDMService(); var list = _bdmSvc.GetViewOfAllEntities("QST"); }
public GLController() { _pqsSvc = new PQSService(); _bdmSvc = new BDMService(); //_mockingFlag = true; }
public bool ModifyGiftType(GiftTypeBE mod) { EntityDE ety = new EntityDE(); ety.SiteCode = mod.SiteCode; ety.EntityTypeCode = mod.EntityTypeCode; ety.ID = mod.ID; ety.EntityName = mod.EntityName; ety.Code = mod.Code; ety.IsActive = mod.IsActive; SqlConnection con = new SqlConnection(DBHelper.ConnectionString); try { //mod.ID = GetNextEntityId(mod.SiteCode, mod.EntityTypeCode); StringBuilder sb = new StringBuilder(); using (TransactionScope trans = new TransactionScope()) { _bdmSvc = new BDMService(); if (_bdmSvc.ModifyEntity(ety)) { SqlCommand cmd = new SqlCommand(); #region CommandText & Params sb.Append("UPDATE [dbo].[GiftType] SET "); sb.Append("[GiftTypeID] = @GiftTypeID"); sb.Append(",[IsCondition] = @IsCondition"); sb.Append(",[Price] = @Price"); sb.Append(" WHERE "); sb.Append(" [GiftTypeID] = @GiftTypeID"); cmd.Parameters.AddWithValue("@GiftTypeID", mod.ID); cmd.Parameters.AddWithValue("@IsCondition", mod.IsCondition); cmd.Parameters.AddWithValue("@Price", mod.Price); #endregion cmd.Connection = con; cmd.CommandText = sb.ToString(); con.Open(); cmd.ExecuteNonQuery(); trans.Complete(); } } } catch (Exception ex) { return false; } finally { con.Close(); } return true; }
public BDMController() { _bdmSvc = new BDMService(); }