public T Show(JGridRequest packet)
{
var pk = GetPrimaryKeyInfo <T>();
var pkType = pk.PropertyType;
return(unitOfWork.GenericRepositories <T>().GetById(Convert.ChangeType(packet.RecordId, pkType)));
}
public string getSelector(JGridRequest packet)
{
FilterData filter = new FilterData();
filter = JsonConvert.DeserializeObject <FilterData>(packet.Data.ToString());
packet.ModelName = GetSwitch(packet.ModelName);
sql = string.Format(@"SELECT * FROM {0}", filter.ModelName);
switch (packet.ModelName)
{
case "DistributionPlanView":
sql = string.Format($@"EXEC Report_DistributionPlan '{filter.CampId}','','{filter.FromDate}','999999','1'");
break;
case "UserWiseServiceCountReportView":
sql = $@"EXEC UserWiseServiceCount '{filter.Users}','{filter.FromDate}','{filter.ToDate}','{filter.BlockId}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','1','999999'";
break;
case "DailyProgressReportView":
sql = $@"EXEC Report_IndicatorInfo '{filter.Program}','{filter.FromDate}','{filter.ToDate}','{filter.BlockId}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}'";
break;
case "MemberInfo":
sql = $@"EXEC ExportMemberInfo '{filter.FromDate}','{filter.ToDate}','{filter.BenId}','{filter.Users}','{filter.BlockId}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}'";
break;
}
return(sql);
}
public T GetVerifyInfo(JGridRequest packet, string pkName)
{
var sql = string.Format(@"SELECT ISNULL(ud.FullName, '') as UserName,
d.EntryDate as DataCollectionDate
,ISNULL(d.IsVerified,0) as IsVerified
,ISNULL(u.FullName,'') as VerifierName
,d.VerificationDate as VerificationDate
,ISNULL(d.VerificationNote,'') as VerificationNote
FROM {0} d
LEFT JOIN AspNetUsers u on u.UserId = d.VerifiedBy
LEFT JOIN AspNetUsers ud on ud.UserId = d.UserId
WHERE d.{1} = '{2}'", packet.ModelName, pkName, packet.RecordId);
return(unitOfWork.GenericRepositories <T>().GetRecordSet(sql).FirstOrDefault());
}
public string getSelector(JGridRequest packet)
{
FilterData filter = new FilterData();
if (packet.Data != null && packet.RequestType != "Update")
{
filter = JsonConvert.DeserializeObject <FilterData>(packet.Data.ToString());
}
switch (packet.ModelName)
{
case "GmpTrandView":
sql = string.Format(@"EXEC GetGmpTrand '{0}'", packet.RecordId);
break;
}
return(sql);
}
public object Insert(JGridRequest packet, Assembly[] asm, Type item)
{
string tableName = typeof(T).Name;
var pk = GetPrimaryKeyInfo <T>();
var pkType = pk.PropertyType;
var requestSourceDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(packet.Data.ToString());
var obj = Activator.CreateInstance(item);
foreach (var items in requestSourceDictionary)
{
var destinationType = obj.GetType();
var destinationField = destinationType.GetProperty(items.Key);
Type fieldType = Nullable.GetUnderlyingType(destinationField.PropertyType) ?? destinationField.PropertyType;
var fieldValue = (items.Value == null || items.Value == "") ? null : Convert.ChangeType(items.Value, fieldType);
destinationField.SetValue(obj, fieldValue, null);
}
unitOfWork.GenericRepositories <T>().Insert((T)obj);
unitOfWork.SaveChange();
return("Operation Succeeded.");
}
public object EditDelete(int operationType, JGridRequest packet, Assembly[] asm, int?SessionUserId)
{
string tableName = typeof(T).Name;
var pk = GetPrimaryKeyInfo <T>();
var pkType = pk.PropertyType;
if (operationType == 1)
{
var requestSourceDictionary = JsonConvert.DeserializeObject <Dictionary <string, string> >(packet.Data.ToString());
var ids = packet.RecordId.Split(',');
List <T> list = new List <T>();
foreach (var recordId in ids)
{
var exist = unitOfWork.GenericRepositories <T>().GetById(Convert.ChangeType(recordId, pkType));
foreach (var item in requestSourceDictionary)
{
var destinationType = exist.GetType();
var destinationField = destinationType.GetProperty(item.Key);
if (destinationField != null)
{
Type fieldType = Nullable.GetUnderlyingType(destinationField.PropertyType) ?? destinationField.PropertyType;
var fieldValue = (item.Value == null || item.Value == "") ? null : Convert.ChangeType(item.Value, fieldType);
destinationField.SetValue(exist, fieldValue, null);
}
}
list.Add(exist);
//// For log
//InsertVerificationLog(packet.ModelName, 1, pk.Name, Convert.ToInt64(recordId), Convert.ToString(exist.GetPropertyValue("UUID") ?? ""), Convert.ToInt32(exist.GetPropertyValue("UserId") ?? 0), SessionUserId ?? 0, packet.RecordType, "");
////End
}
unitOfWork.GenericRepositories <T>().UpdateAll(list);
}
else if (operationType == 2)
{
var ChildTables = "";
if (packet.RecordType == "Master")
{
var childList = GetChildTableList <T>();
var query = unitOfWork.GenericRepositories <T>().GetAll().Where($"{pk.Name} = {packet.RecordId}");
//Child Include Start
foreach (var childitem in childList.ToList())
{
query = query.Include(childitem);
}
//Child Include End
var existingMasterWithChild = query.FirstOrDefault();
Type item = null;
foreach (var childListItem in childList)
{
if (ChildTables == "")
{
ChildTables += childListItem;
}
else
{
ChildTables += "," + childListItem;
}
for (int i = 0; i < asm.Length; i++)
{
item = asm[i].GetTypes().Where(x => x.Name == childListItem).FirstOrDefault();
if (item != null)
{
var jgridType = typeof(Repository <>);
var jgridObject = jgridType.MakeGenericType(item);
var obj = Activator.CreateInstance(jgridObject, unitOfWork.context);
var childs = (IEnumerable <object>)existingMasterWithChild.GetPropertyValue(childListItem);
////For log
//foreach (var childItem in childs)
//{
// //var primaryKey = _utilityHelper.GetPrimaryKeyInfo(childItem.GetType()).Name.ToString();
// ////InsertVerificationLog(childItem.GetType().Name, primaryKey, Convert.ToInt64(childItem.GetPropertyValue(primaryKey) ?? 0), Convert.ToInt32(childItem.GetPropertyValue("UserId") ?? 0), Convert.ToInt32(childItem.GetPropertyValue("ModifiedBy") ?? 0), packet.RecordType);
// //InsertVerificationLog(childItem.GetType().Name, 2, primaryKey, Convert.ToInt64(childItem.GetPropertyValue(primaryKey) ?? 0), Convert.ToString(exist.GetPropertyValue("UUID") ?? ""), Convert.ToInt32(exist.GetPropertyValue("UserId") ?? 0), Convert.ToInt32(CurrentUser ?? "0"), packet.RecordType);
//}
//// End
MethodInvoker("DeleteAll", obj, new object[] { childs });
break;
}
}
}
//Master Table Data Delete
unitOfWork.GenericRepositories <T>().Delete(existingMasterWithChild);
// For log
var PK = _utilityHelper.GetPrimaryKeyInfo(existingMasterWithChild.GetType()).Name.ToString();
// InsertVerificationLog(existingMasterWithChild.GetType().Name, 2, PK, Convert.ToInt64(existingMasterWithChild.GetPropertyValue(PK) ?? 0), Convert.ToString(existingMasterWithChild.GetPropertyValue("UUID") ?? ""), Convert.ToInt32(existingMasterWithChild.GetPropertyValue("UserId") ?? 0), SessionUserId ?? 0, packet.RecordType, ChildTables);
//// End
}
else
{
var exist = unitOfWork.GenericRepositories <T>().GetById(Convert.ChangeType(packet.RecordId, pkType));
unitOfWork.GenericRepositories <T>().Delete(exist);
//// For log
//InsertVerificationLog(packet.ModelName, 2, pk.Name, Convert.ToInt64(packet.RecordId), Convert.ToString(exist.GetPropertyValue("UUID") ?? ""), Convert.ToInt32(exist.GetPropertyValue("UserId") ?? 0), SessionUserId ?? 0, packet.RecordType,ChildTables);
//// End
}
}
unitOfWork.SaveChangeJGrid();
return("Operation Succeeded.");
}
public string getSelector(JGridRequest packet)
{
FilterData filter = new FilterData();
if (packet.Data != null && packet.RequestType != "Update")
{
filter = JsonConvert.DeserializeObject <FilterData>(packet.Data.ToString());
}
switch (packet.ModelName)
{
case "MemberInfoView":
sql = string.Format(@"EXEC SearchMemberInfoData '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}'",
filter.FromDate, filter.ToDate, filter.BenId, filter.BenName, filter.BenType,
filter.BenUsers, filter.DistrictCode, filter.UpazilaCode, filter.UnionCode, filter.VillageCode,
filter.CenterId, filter.CampId, filter.BlockId, packet.PageSize, packet.PageNo);
break;
case "MemberDetailView":
sql = string.Format(@"exec SearchMemberInfoDetailData '{0}'", packet.RecordId);
break;
case "SessionInfoView":
sql = string.Format(@"EXEC SearchSessionInfoMasterData '{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}'",
filter.FromDate, filter.ToDate, filter.CategoryId, filter.GroupId, filter.SessionAttendance,
filter.IndividualAttendance, filter.CenterId, filter.Users, filter.BenId,
filter.DistrictCode, filter.UpazilaCode, filter.UnionCode, filter.VillageCode, packet.PageSize, packet.PageNo, filter.BlockId);
break;
case "SessionMemberInfoView":
sql = string.Format(@"EXEC SessionInfoDetails '{0}'", packet.RecordId);
break;
case "SessionInfoSummaryView":
sql = string.Format(@"EXEC SessionInfoSummaryDetails '{0}'", packet.RecordId);
break;
case "SessionInfoTopicView":
sql = string.Format(@"EXEC SearchSessionInfoTopicData '{0}'", packet.RecordId);
break;
case "SessionMemberGuardiansView":
sql = string.Format(@"EXEC SearchSessionMemberGuardiansData '{0}'", packet.RecordId);
break;
case "GmpView":
sql = $@"EXEC SearchGmpMaster '{filter.FromDate}','{filter.ToDate}','{filter.Users}','{filter.BenId}','{filter.BenName}','{filter.BenType}','{filter.BenStatus}','{filter.InCare}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','{filter.CenterId}','{packet.PageSize}','{packet.PageNo}'";
break;
case "GmpDetailsView":
sql = $@"EXEC GmpDetailsByRecordId '{packet.RecordId}'";
break;
case "AdmissionView":
////sql = $@"EXEC SearchAdmission '{filter.FromDate}','{filter.ToDate}','{filter.Block}','{filter.ServicePointId}','{filter.Users}','{filter.BenId}','{filter.BenName}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','{packet.PageSize}','{packet.PageNo}'";
sql = $@"EXEC SearchAdmissionMaster '{filter.FromDate}','{filter.ToDate}','{filter.CenterId}','{filter.Users}','{filter.BenId}','{filter.BenName}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','{packet.PageSize}','{packet.PageNo}','{filter.BlockId}','{filter.AdmissionType}','{filter.DischargeType}'";
break;
case "AdmissionDetailsView":
sql = $@"EXEC SearchAdmissionDetailsByRecordId '{packet.RecordId}'";
break;
case "DischargeView":
sql = $@"EXEC SearchDischargeByRecordId '{packet.RecordId}'";
break;
case "DistributionView":
sql = $@"EXEC SearchDistribution '{filter.FromDate}','{filter.ToDate}','{filter.Users}','{filter.BenId}','{filter.BenName}','{filter.BenType}','{filter.BenStatus}','{filter.InCare}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','{filter.CenterId}','{packet.PageSize}','{packet.PageNo}'";
break;
case "DistributionDetailsView":
sql = $@"EXEC SearchDistributionByBenId '{packet.RecordId}'";
break;
case "DailyProgressReportView":
sql = $@"EXEC Report_IndicatorInfo '{filter.Program}','{filter.FromDate}','{filter.ToDate}','{filter.BlockId}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}'";
break;
case "UserWiseServiceCountReportView":
sql = $@"EXEC UserWiseServiceCount '{filter.Users}','{filter.FromDate}','{filter.ToDate}','{filter.BlockId}','{filter.DistrictCode}','{filter.UpazilaCode}','{filter.UnionCode}','{filter.VillageCode}','{packet.PageNo}','{packet.PageSize}'";
break;
case "DistributionPlanView":
sql = $@"EXEC Report_DistributionPlan '{filter.CampId}','{filter.StatusType}','{filter.FromDate}','{packet.PageSize}','{packet.PageNo}'";
break;
}
return(sql);
}