public JsonResult GetGroupName(int id)
{
GroupMasterDto groupMasterDto = _groupService.GetByID(id);
PanchayatLookupDto panchayatlookupDto = _panchayatService.GetByGroupID(id);
return(Json(new { VillageName = panchayatlookupDto.Village, ClusterName = panchayatlookupDto.Cluster, GroupName = groupMasterDto.GroupName, VillageCode = panchayatlookupDto.VillageCode, ClusterCode = panchayatlookupDto.ClusterCode }));
}
public ActionResult SelectGroup(int groupId)
{
//int iGroupId = default(int);
//int.TryParse(groupId.DecryptString(), out iGroupId);
if (groupId < 1)
{
return(Json(new { isSueecess = false }));
}
try
{
GroupService _groupService = new GroupService();
GroupMasterDto group = _groupService.GetByID(groupId);
ViewBag.lstGroups = group;
GroupInfo objGroupInfo = new BusinessEntities.GroupInfo();
objGroupInfo.GroupID = groupId;
objGroupInfo.GroupName = group.GroupName;
objGroupInfo.GroupCode = group.GroupCode;
objGroupInfo.TEGroupName = group.TEGroupName;
objGroupInfo.Village = group.Village;
objGroupInfo.Cluster = group.ClusterName;
objGroupInfo.MeetingDay = group.MeetingDay;
objGroupInfo.MeetingDate = group.MeetingDate;
objGroupInfo.LockStatus = group.LockStatus;
objGroupInfo.LockStatusCode = group.LockStatusCode;
GroupInfo = objGroupInfo;
return(Json(new { isSueecess = true }));
}
catch (Exception ex)
{
throw ex;
}
}
public ActionResult CreateGroup(int?id)
{
GroupModel groupModel = new GroupModel();
List <SelectListDto> lstVillages = _villageService.GetVillageSelectList();
SelectList slVillages = new SelectList(lstVillages, "ID", "Text");
List <SelectListDto> lstClusters = _clusterService.GetClusterSelectList();
SelectList slClusters = new SelectList(lstClusters, "ID", "Text");
SelectList slMeetingFrrequency = GetDropDownListByMasterCode(Enums.RefMasterCodes.MEETING_FREQUENCY);
List <SelectListDto> lstpanchayats = _panchayatService.GetPanchayatSelectList();
SelectList slPanchayat = new SelectList(lstpanchayats, "ID", "Text");
ViewBag.villages = slVillages;
ViewBag.clusters = slClusters;
ViewBag.panchayats = slPanchayat;
ViewBag.MeetingFrrequency = slMeetingFrrequency;
GroupMasterDto groupMasterDto = new GroupMasterDto();
if (id.HasValue && id.Value > 0)
{
groupMasterDto = _groupService.GetByID(id.Value);
groupModel = AutoMapperEntityConfiguration.Cast <GroupModel>(groupMasterDto);
}
LoadRegularSavingAccountHeadDropDown();
ViewBag.Result = new ResultDto();
return(View("CreateGroup", groupModel));
}
public ActionResult CreateGroup(GroupModel objGroupModel)
{
List <GroupMasterDto> lstObjGroup = new List <GroupMasterDto>();
ResultDto resultDto = new ResultDto();
int groupId = default(int);
byte meetingDay = default(byte);
int.TryParse(Request.Form["hdnObjectID"], out groupId);
byte.TryParse(Request.Form["hdnMeetingDay"], out meetingDay);
var groupMasterDTO = new GroupMasterDto()
{
GroupCode = objGroupModel.GroupCode,
GroupID = groupId,
GroupName = objGroupModel.GroupName,
GroupRefNumber = objGroupModel.GroupRefNumber,
TEGroupName = objGroupModel.TEGroupName,
MeetingDay = meetingDay,
MeetingEndTime = objGroupModel.MeetingEndTime,
MeetingFrequency = objGroupModel.MeetingFrequency,
MeetingStartTime = objGroupModel.MeetingStartTime,
PanchayatID = objGroupModel.PanchayatID,
ClusterID = objGroupModel.ClusterID,
Phone = objGroupModel.Phone,
FormationDate = objGroupModel.FormationDate,
FederationTranStartDate = objGroupModel.FederationTranStartDate,
DateOfClosure = objGroupModel.DateOfClosure,
Email = objGroupModel.Email,
Address = objGroupModel.Address,
UserId = UserInfo.UserID,
RegularSavingAmount = objGroupModel.RegularSavingAmount,
RegularSavingsAhId = objGroupModel.RegularSavingsAhId
};
if (objGroupModel.GroupID == 0)
{
resultDto = _groupService.Insert(groupMasterDTO);
}
else
{
resultDto = _groupService.Update(groupMasterDTO);
}
return(Json(new { groupid = resultDto.ObjectId, GroupCode = resultDto.ObjectCode, Message = resultDto.Message }));
}
public List <GroupMasterDto> GetByEmployeeId(int employeeId)
{
List <GroupMasterDto> objGroupMasterDto = new List <GroupMasterDto>();
List <uspGroupDetailsGetByEmployeeId_Result> lstuspGroupGetByGroupId_Result = _dbContext.uspGroupDetailsGetByEmployeeId(employeeId).ToList();
foreach (var Item in lstuspGroupGetByGroupId_Result)
{
GroupMasterDto objgroup = new GroupMasterDto();
objgroup.GroupID = Item.GroupID;
objgroup.GroupName = Item.GroupName;
objgroup.GroupCode = Item.GroupCode;
objgroup.TEGroupName = Item.TEGroupName;
objgroup.Village = Item.Village;
objgroup.ClusterName = Item.ClusterName;
objGroupMasterDto.Add(objgroup);
}
return(objGroupMasterDto);
}
public void UpdateGroupInfoSessionbyGroupId(int groupId)
{
GroupService _groupService = new GroupService();
GroupMasterDto group = _groupService.GetByID(groupId);
GroupInfo objGroupInfo = new BusinessEntities.GroupInfo();
objGroupInfo.GroupID = groupId;
objGroupInfo.GroupName = group.GroupName;
objGroupInfo.GroupCode = group.GroupCode;
objGroupInfo.TEGroupName = group.TEGroupName;
objGroupInfo.Village = group.Village;
objGroupInfo.Cluster = group.ClusterName;
objGroupInfo.MeetingDay = group.MeetingDay;
objGroupInfo.MeetingDate = group.MeetingDate;
objGroupInfo.LockStatus = group.LockStatus;
objGroupInfo.LockStatusCode = group.LockStatusCode;
GroupInfo = objGroupInfo;
}
private ResultDto InsertUpdateGroup(GroupMasterDto objgroup)
{
bool isSuccess = true;
ResultDto resultDto = new ResultDto();
string GroupCode = "";
try
{
ObjectParameter paramGroupID = new ObjectParameter("GroupID", objgroup.GroupID);
ObjectParameter paramGroupCode = new ObjectParameter("GroupCode", string.Empty);
decimal?regularSavingAmount = objgroup.RegularSavingAmount;
int? regularSavingAhId = objgroup.RegularSavingsAhId;
int COUNT = _dbContext.uspGroupInsertUpdate(paramGroupID, objgroup.GroupRefNumber, objgroup.GroupName, objgroup.TEGroupName, objgroup.PanchayatID, objgroup.FormationDate, objgroup.Phone, objgroup.Email, objgroup.Address, objgroup.MeetingFrequency, objgroup.FederationTranStartDate, objgroup.DateOfClosure, objgroup.MeetingDay, objgroup.MeetingStartTime, objgroup.MeetingEndTime, regularSavingAmount, regularSavingAhId, objgroup.UserId, paramGroupCode);
GroupCode = Convert.ToString(paramGroupCode.Value);
resultDto.ObjectId = Convert.ToInt32(paramGroupID.Value);
resultDto.ObjectCode = Convert.ToString(paramGroupCode.Value);
int GroupId = (int)paramGroupID.Value;
if (GroupId > 0)
{
resultDto.Message = "Group details saved success fully";
}
else if (GroupId == -1)
{
resultDto.Message = "Group occured while generating Group code";
}
else
{
resultDto.Message = "Group occured while saving Group details";
}
}
catch (Exception)
{
resultDto.Message = "Service layer error occured while saving the bank details";
resultDto.ObjectId = -98;
}
return(resultDto);
}
public JsonResult GetGroupName(int id)
{
GroupMasterDto groupMasterDto = _groupService.GetByID(id);
return(Json(new { GroupName = groupMasterDto.GroupName }));
}
public ResultDto Update(GroupMasterDto group)
{
return(InsertUpdateGroup(group));
}
public GroupMasterDto GetGroupMasterDetailsByID(int groupID)
{
GroupMasterDto grp = new GroupMasterDto();
AdoHelper obj = new AdoHelper();
SqlParameter[] parms = new SqlParameter[1];
parms[0] = new SqlParameter("@GroupId", groupID);
parms[0].SqlDbType = System.Data.SqlDbType.Int;
SqlDataReader dr = obj.ExecDataReaderProc("uspGroupGetByGroupId", parms);
if (dr.Read())
{
grp.GroupID = Convert.ToInt32(dr["GroupID"]);
grp.GroupCode = Convert.ToString(dr["GroupCode"]);
grp.GroupRefNumber = Convert.ToString(dr["GroupRefNumber"]);
grp.GroupName = Convert.ToString(dr["GroupName"]);
grp.TEGroupName = Convert.ToString(dr["TEGroupName"]);
grp.PanchayatID = Convert.ToInt32(dr["PanchayatID"]);
grp.VillageID = Convert.ToInt32(dr["VillageID"]);
grp.ClusterID = Convert.ToInt32(dr["ClusterID"]);
grp.ClusterName = Convert.ToString(dr["ClusterName"]);
grp.Village = Convert.ToString(dr["Village"]);
if (dr["FormationDate"] != DBNull.Value)
{
grp.FormationDate = Convert.ToDateTime(dr["FormationDate"]);
}
grp.Phone = Convert.ToString(dr["Phone"]);
grp.Email = Convert.ToString(dr["Email"]);
grp.Address = Convert.ToString(dr["Address"]);
if (dr["MeetingFrequency"] != DBNull.Value)
{
grp.MeetingFrequency = Convert.ToInt32(dr["MeetingFrequency"]);
}
if (dr["FederationTranStartDate"] != DBNull.Value)
{
grp.FederationTranStartDate = Convert.ToDateTime(dr["FederationTranStartDate"]);
}
if (dr["DateOfClosure"] != DBNull.Value)
{
grp.DateOfClosure = Convert.ToDateTime(dr["DateOfClosure"]);
}
if (dr["MeetingDay"] != DBNull.Value)
{
grp.MeetingDay = Convert.ToByte(dr["MeetingDay"]);
}
if (dr["MeetingStartTime"] != DBNull.Value)
{
grp.MeetingStartTime = (TimeSpan)dr["MeetingStartTime"];
}
if (dr["MeetingEndTime"] != DBNull.Value)
{
grp.MeetingEndTime = (TimeSpan)dr["MeetingEndTime"];
}
if (dr["RegularSavingAmount"] != DBNull.Value)
{
grp.RegularSavingAmount = Convert.ToDecimal(dr["RegularSavingAmount"]);
}
if (dr["RegularSavingsAhId"] != DBNull.Value)
{
grp.RegularSavingsAhId = Convert.ToInt32(dr["RegularSavingsAhId"]);
}
grp.RegularSavingAccountHead = Convert.ToString(dr["RegularSavingAccountHead"]);
if (dr["MeetingDate"] != DBNull.Value)
{
grp.MeetingDate = Convert.ToDateTime(dr["MeetingDate"]);
}
grp.LockStatus = Convert.ToString(dr["LockStatus"]);
grp.LockStatusCode = Convert.ToString(dr["LockStatusCode"]);
}
return(grp);
}
public JsonResult BindMeetingDay(int ID)
{
GroupMasterDto groupdto = _groupService.GetByID(ID);
return(Json(new { DueDay = groupdto.MeetingDay }));
}
