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;
}
//[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 bool ModifyEntity(EntityDE mod)
{
SqlConnection con = new SqlConnection(DBHelper.ConnectionString);
try
{
//mod.ID = GetNextEntityId(mod.SiteCode, mod.EntityTypeCode);
StringBuilder sb = new StringBuilder();
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required))
{
SqlCommand cmd = new SqlCommand();
#region CommandText & Params
sb.Append("UPDATE [dbo].[Entity] SET ");
sb.Append("[Code] = @Code");
sb.Append(",[EntityName] = @EntityName");
sb.Append(",[IsActive] = @IsActive");
sb.Append(" WHERE ");
sb.Append(" [SiteCode] = @SiteCode");
sb.Append(" AND [ID] = @ID");
sb.Append(" AND [EntityTypeCode] = @EntityTypeCode");
cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode);
cmd.Parameters.AddWithValue("@ID", mod.ID);
cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode);
cmd.Parameters.AddWithValue("@Code", mod.Code);
cmd.Parameters.AddWithValue("@EntityName", mod.EntityName);
cmd.Parameters.AddWithValue("@IsActive", mod.IsActive);
#endregion
cmd.Connection = con;
cmd.CommandText = sb.ToString();
con.Open();
cmd.ExecuteNonQuery();
trans.Complete();
}
}
catch (Exception ex)
{
return false;
}
finally
{
con.Close();
}
return true;
//_etyRepo.Update(mod);
//foreach (var add in mod.Addresses)
// _addRepo.Update(add);
//foreach (var cnt in mod.Contacts)
// _cntRepo.Update(cnt);
////_uow.Context.Entry(mod).State = EntityState.Modified;
//_etyRepo.CommitAllChanges();
}
public EntityDE GetEntityById(string siteCode, string entityTypeCode, int id)
{
EntityDE mod = new EntityDE();
SqlConnection con = new SqlConnection(DBHelper.ConnectionString);
try
{
//using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required))
{
StringBuilder sb = new StringBuilder();
SqlCommand cmd = new SqlCommand();
sb.Append("SELECT * FROM [dbo].[Entity]");
sb.Append(" WHERE [SiteCode] = @SiteCode");
sb.Append(" AND [EntityTypeCode]=@EntityTypeCode");
sb.Append(" AND [ID]=@ID");
cmd.Parameters.AddWithValue("@SiteCode", siteCode);
cmd.Parameters.AddWithValue("@EntityTypeCode", entityTypeCode);
cmd.Parameters.AddWithValue("@ID", id);
cmd.Connection = con;
cmd.CommandText = sb.ToString();
con.Open();
SqlDataReader rdr = cmd.ExecuteReader();
if (rdr.HasRows)
{
while (rdr.Read())
{
mod.Code = rdr["Code"] != DBNull.Value ? (string)rdr["Code"] : string.Empty;
mod.EntityName = rdr["EntityName"] != DBNull.Value ? (string)rdr["EntityName"] : string.Empty;
mod.IsActive = rdr["IsActive"] != DBNull.Value ? (bool)rdr["IsActive"] : false;
}
}
else
mod = null;
//trans.Complete();
}
}
catch (Exception ex)
{
mod = null;
}
finally
{
con.Close();
}
return mod;
}
//private int AddEntity(EntityDE mod, )
public int AddEntity(EntityDE mod)
{
int retVal = 0;
SqlConnection con = new SqlConnection(DBHelper.ConnectionString);
try
{
//trans.Commit();
mod.ID = GetNextEntityId(mod.SiteCode, mod.EntityTypeCode);
StringBuilder sb = new StringBuilder();
using (TransactionScope trans = new TransactionScope(TransactionScopeOption.Required))
{
SqlCommand cmd = new SqlCommand();
#region CommandText & Params
sb.Append("INSERT INTO [dbo].[Entity]");
sb.Append("([SiteCode]");
sb.Append(",[ID]");
sb.Append(",[EntityTypeCode]");
sb.Append(",[Code]");
sb.Append(",[EntityName]");
sb.Append(",[IsActive])");
sb.Append("VALUES");
sb.Append("(@SiteCode");
sb.Append(",@ID");
sb.Append(",@EntityTypeCode");
sb.Append(",@Code");
sb.Append(",@EntityName");
sb.Append(",@IsActive)");
cmd.Parameters.AddWithValue("@SiteCode", mod.SiteCode);
cmd.Parameters.AddWithValue("@ID", mod.ID);
cmd.Parameters.AddWithValue("@EntityTypeCode", mod.EntityTypeCode);
cmd.Parameters.AddWithValue("@Code", mod.Code);
cmd.Parameters.AddWithValue("@EntityName", mod.EntityName);
cmd.Parameters.AddWithValue("@IsActive", mod.IsActive);
#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 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 ManagerViewModel()
{
Address = new AddressDE();
Contact = new ContactDE();
Manager = new EntityDE(EntityTypes.MGR);
Managers = new List<EntityView>();
Cities = new List<CityDE>();
Areas = new List<AreaDE>();
Regions = new List<RegionDE>();
}
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;
}