public static bool Add(DepartmentXAreaIncharge info)
{
if (info.VillageId != 0)
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaIncharges(DepartmentId, StateId, CityId,VillageId,LocalityId, InchargeId)values('{0}','{1}','{2}','{3}','{4}','{5}')", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.InchargeId)));
}
else
{
return(BaseDataAccess.ExecuteSQL(String.Format("insert into DepartmentXAreaIncharges(DepartmentId, StateId, CityId,LocalityId, InchargeId)values('{0}','{1}','{2}','{3}','{4}')", info.DepartmentId, info.StateId, info.CityId, info.LocalityId, info.InchargeId)));
}
}
public static DepartmentXAreaIncharge GetDetails(int id)
{
DepartmentXAreaIncharge info = null;
info = BaseDataAccess.GetRecords <DepartmentXAreaIncharge>(String.Format("select * from DepartmentXAreaIncharges where Id='{0}'", id));
info.Department = DepartmentDA.GetDetails(info.DepartmentId);
info.State = StateDA.GetDetails(info.StateId);
info.City = CityDA.GetDetails(info.CityId);
if (info.VillageId != 0)
{
info.Village = VillageDA.GetDetails(info.VillageId);
}
info.Locality = LocalityDA.GetDetails(info.LocalityId);
info.GovernmentOfficial = GovernmentOfficialDA.GetDetails(info.InchargeId);
return(info);
}
/// <summary>
/// This Function is used to Delete previously added DepartmentXAreaIncharge from database and is performed by SuperAdmin Only.
/// </summary>
public static bool Delete(DepartmentXAreaIncharge info)
{
return(DepartmentXAreaInchargeDA.Delete(info));
}
/// <summary>
/// This Function is used to Update previously added DepartmentXAreaIncharge in database and is performed by SuperAdmin Only.
/// </summary>
public static bool Update(DepartmentXAreaIncharge info)
{
return(DepartmentXAreaInchargeDA.Update(info));
}
/// <summary>
/// This Function is used to add new DepartmentXAreaIncharge to database and is performed by SuperAdmin Only.
/// </summary>
public static bool Add(DepartmentXAreaIncharge info)
{
return(DepartmentXAreaInchargeDA.Add(info));
}
public static bool Delete(DepartmentXAreaIncharge info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("delete from DepartmentXAreaIncharges where Id='{0}'", info.Id)));
}
public static bool Update(DepartmentXAreaIncharge info)
{
return(BaseDataAccess.ExecuteSQL(String.Format("update DepartmentXAreaIncharges set DepartmentId='{0}',StateId='{1}',CityId='{2}',VillageId='{3}',LocalityId='{4}',InchargeId='{5}' where Id='{6}'", info.DepartmentId, info.StateId, info.CityId, info.VillageId, info.LocalityId, info.InchargeId, info.Id)));
}
