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