示例#1
0
        public Result UpdateSubUser(subUserDetails inSubUser)
        {
            try
            {
                int?count = 0;
                using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context())
                {
                    count = db1.InConfiguration.Where(x => x.ConfId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId).Select(x => x.Branch).FirstOrDefault();
                }

                InBranch inBranch1 = new InBranch();
                using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
                {
                    var Bcount = db.InSubUser.Where(x => x.ConfigId == inSubUser.ConfigId && x.EmpId == inSubUser.EmpId && x.Id != inSubUser.Id).Count();
                    if (Bcount < count)
                    {
                        var data = db.InSubUser.Where(x => x.Id == inSubUser.Id && x.EmpId == inSubUser.EmpId).FirstOrDefault();
                        data.ConfigId    = inSubUser.ConfigId;
                        data.SubUserName = inSubUser.SubUserName;
                        data.EmpId       = inSubUser.EmpId;
                        data.EmailId     = inSubUser.EmailId;
                        data.UpdatedBy   = inSubUser.CreatedBy;
                        data.UpdatedDate = inSubUser.CreatedDate;
                        var result = db.SaveChanges();
                        if (result == 1)
                        {
                            return(new Result {
                                StatusCode = 1, Message = "Sub User Updated successfully..!"
                            });
                        }
                        else
                        {
                            return(new Result {
                                StatusCode = -1, Message = "Sub User Failed..!"
                            });
                        }
                    }
                    else
                    {
                        return(new Result {
                            StatusCode = -1, Message = "Sub User count cannot be more than Configuration Count.!"
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                return(new Result {
                    StatusCode = -1, Message = ex.Message
                });

                throw ex;
            }
        }
示例#2
0
        public Result AddBranch(InBranchDetails inBranch)
        {
            try
            {
                int?count = 0;
                using (DB_A3E3FF_scampusMaster2020Context db1 = new DB_A3E3FF_scampusMaster2020Context())
                {
                    count = db1.ConfigurationMaster.Where(x => x.ConfigId == inBranch.ConfigId).Select(x => x.NoOfBranches).FirstOrDefault();
                }

                InBranch inBranch1 = new InBranch();
                using (DB_A3E3FF_scampus2020Context db = new DB_A3E3FF_scampus2020Context())
                {
                    var Bcount = db.InBranch.Where(x => x.ConfigId == inBranch.ConfigId && x.EmpId == inBranch.EmpId && x.BranchId != inBranch.BranchId).Where(x => x.IsActive == true).Count();
                    if (Bcount < count)
                    {
                        inBranch1.BranchName      = inBranch.BranchName;
                        inBranch1.Location        = inBranch.Location;
                        inBranch1.Address         = inBranch.Address;
                        inBranch1.ContactNumber1  = inBranch.ContactNumber1;
                        inBranch1.ContactNumber2  = inBranch.ContactNumber2;
                        inBranch1.Email           = inBranch.Email;
                        inBranch1.ContactPerson   = inBranch.ContactPerson;
                        inBranch1.BranchCode      = inBranch.BranchCode;
                        inBranch1.Gstin           = inBranch.Gstin;
                        inBranch1.State           = inBranch.State;
                        inBranch1.District        = inBranch.District;
                        inBranch1.Smsapiurl       = inBranch.Smsapiurl;
                        inBranch1.Apikey          = inBranch.Apikey;
                        inBranch1.SenderId        = inBranch.SenderId;
                        inBranch1.BranchLogo      = inBranch.BranchLogo;
                        inBranch1.PrintHeaderFile = inBranch.PrintHeaderFile;
                        inBranch1.PrintFooterFile = inBranch.PrintFooterFile;
                        inBranch1.CreatedBy       = inBranch.CreatedBy;
                        inBranch1.CreatedDate     = inBranch.CreatedDate;
                        inBranch1.EmpId           = inBranch.EmpId;
                        inBranch1.ConfigId        = inBranch.ConfigId;
                        db.InBranch.Add(inBranch1);
                        var result = db.SaveChanges();
                        if (result == 1)
                        {
                            return(new Result {
                                StatusCode = 1, Message = "Branch Added successfully..!"
                            });
                        }
                        else
                        {
                            return(new Result {
                                StatusCode = -1, Message = "Branch Failed..!"
                            });
                        }
                    }
                    else
                    {
                        return(new Result {
                            StatusCode = -1, Message = "Branch count cannot be more than Configuration Count.!"
                        });
                    }
                }
            }
            catch (Exception ex)
            {
                return(new Result {
                    StatusCode = -1, Message = ex.Message
                });

                throw ex;
            }
        }