Example #1
0
        private SukanyaSamrudhi convertToSukanyaSamrudhi(DataRow dr)
        {
            SukanyaSamrudhi SukanyaSamrudhi = new SukanyaSamrudhi();

            SukanyaSamrudhi.Id                   = dr.Field <int>("ID");
            SukanyaSamrudhi.Pid                  = dr.Field <int>("PID");
            SukanyaSamrudhi.InvesterName         = dr.Field <string>("InvesterName");
            SukanyaSamrudhi.AccountNo            = dr.Field <string>("AccountNo");
            SukanyaSamrudhi.Bank                 = dr.Field <string>("Bank");
            SukanyaSamrudhi.OpeningDate          = dr.Field <DateTime>("OpeningDate");
            SukanyaSamrudhi.CurrentValue         = Double.Parse(dr["CurrentValue"].ToString());
            SukanyaSamrudhi.MaturityDate         = dr.Field <DateTime>("MaturityDate");
            SukanyaSamrudhi.GoalId               = dr.Field <int>("GoalId");
            SukanyaSamrudhi.UpdatedBy            = dr.Field <int>("UpdatedBy");
            SukanyaSamrudhi.UpdatedOn            = dr.Field <DateTime>("UpdatedOn");
            SukanyaSamrudhi.UpdatedByUserName    = dr.Field <string>("UpdatedByUserName");
            SukanyaSamrudhi.UpdatedBy            = dr.Field <int>("UpdatedBy");
            SukanyaSamrudhi.UpdatedOn            = dr.Field <DateTime>("UpdatedOn");
            SukanyaSamrudhi.UpdatedByUserName    = dr.Field <string>("UpdatedByUserName");
            SukanyaSamrudhi.InvestmentReturnRate = float.Parse(dr["InvestmentReturnRate"].ToString());
            return(SukanyaSamrudhi);
        }
Example #2
0
        public SukanyaSamrudhi Get(int id)
        {
            try
            {
                Logger.LogInfo("Get: SukanyaSamrudhi by id process start");
                SukanyaSamrudhi SukanyaSamrudhi = new SukanyaSamrudhi();

                DataTable dtAppConfig = DataBase.DBService.ExecuteCommand(string.Format(SELECT_ID, id));
                foreach (DataRow dr in dtAppConfig.Rows)
                {
                    SukanyaSamrudhi = convertToSukanyaSamrudhi(dr);
                }
                Logger.LogInfo("Get: SukanyaSamrudhi by id process completed");
                return(SukanyaSamrudhi);
            }
            catch (Exception ex)
            {
                StackTrace st = new StackTrace();
                StackFrame sf = st.GetFrame(0);
                MethodBase currentMethodName = sf.GetMethod();
                LogDebug(currentMethodName.Name, ex);
                return(null);
            }
        }
Example #3
0
        public void Delete(SukanyaSamrudhi SukanyaSamrudhi)
        {
            try
            {
                string clientName = DataBase.DBService.ExecuteCommandScalar(string.Format(SELECT_ID, SukanyaSamrudhi.Id));

                DataBase.DBService.BeginTransaction();
                DataBase.DBService.ExecuteCommandString(string.Format(DELETE_SukanyaSamrudhi,
                                                                      SukanyaSamrudhi.Id), true);

                Activity.ActivitiesService.Add(ActivityType.DeleteSukanyaSamrudhi, EntryStatus.Success,
                                               Source.Server, SukanyaSamrudhi.UpdatedByUserName, SukanyaSamrudhi.AccountNo, SukanyaSamrudhi.MachineName);
                DataBase.DBService.CommitTransaction();
            }
            catch (Exception ex)
            {
                DataBase.DBService.RollbackTransaction();
                StackTrace st = new StackTrace();
                StackFrame sf = st.GetFrame(0);
                MethodBase currentMethodName = sf.GetMethod();
                LogDebug(currentMethodName.Name, ex);
                throw ex;
            }
        }