Example #1
0
        /// <summary>
        /// Add Refund Info
        /// </summary>
        /// <param name="info"></param>
        /// <returns></returns>
        public bool AddRefund(clsRefund info)
        {
            int st = 0;

            try
            {
                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();

                    {
                        using (SqlCommand cmd = new SqlCommand("TMR_USP_AddRefund"))
                        {
                            cmd.CommandType = CommandType.StoredProcedure;
                            cmd.Connection  = conn;

                            cmd.Parameters.AddWithValue("@RegistrationNo", info.RegistrationOrBookingNo);
                            cmd.Parameters.AddWithValue("@ClientID", info.ClientID);
                            cmd.Parameters.AddWithValue("@ProjectID", info.strProjectid);
                            cmd.Parameters.AddWithValue("@RefundDate", info.RefundDate);
                            cmd.Parameters.AddWithValue("@Approve", info.Approved);
                            cmd.Parameters.AddWithValue("@Remarks", info.Remarks);
                            cmd.Parameters.AddWithValue("@Profit", info.decProfit);
                            cmd.Parameters.AddWithValue("@Deduction", info.decDeduction);
                            cmd.Parameters.AddWithValue("@TaxWithheld", info.decTax);
                            cmd.Parameters.AddWithValue("@Net", info.decNet);
                            cmd.Parameters.AddWithValue("@ApprovalStatusCode", info.ApprovalStatusCode);
                            cmd.Parameters.AddWithValue("@ApprovalActionUser", info.ApprovalActionUser);
                            cmd.Parameters.AddWithValue("@ApprovalActionDate", info.ApprovalActionDate);
                            cmd.Parameters.AddWithValue("@CreatedBy", info.CreatedBy);
                            cmd.Parameters.AddWithValue("@CreationDate", info.CreationDate);
                            cmd.Parameters.AddWithValue("@LastUpdateUser", info.LastUpdateUser);
                            cmd.Parameters.AddWithValue("@LastUpdateDate", info.LastUpdateDate);
                            cmd.Parameters.AddWithValue("@PreviousStatusCode", info.intPreviousStatusCode);
                            cmd.Parameters.AddWithValue("@id", info.id);


                            st = cmd.ExecuteNonQuery();
                        }
                    }
                    conn.Close();
                }
            }
            catch (Exception ex) { }
            if (st > 0)
            {
                return(true);
            }
            else
            {
                return(false);
            }
        }
Example #2
0
        /// <summary>
        /// Get All Refund Info
        /// </summary>
        /// <returns></returns>
        ///
        public List <clsRefund> GetAllRefundList(clsDocumentFilter clsdoc)
        {
            List <clsRefund> lst = new List <clsRefund>();

            using (SqlConnection conn = new SqlConnection(strConn))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand("TMR_USP_GetAllRefund"))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection  = conn;

                    cmd.Parameters.AddWithValue("@RegistrationNo", clsdoc.strRegistrationNo);
                    cmd.Parameters.AddWithValue("@ProjectID", clsdoc.strProjectID);
                    cmd.Parameters.AddWithValue("@ClientID", clsdoc.strClientID);
                    cmd.Parameters.AddWithValue("@StartDate", clsdoc.dateStartDate);
                    cmd.Parameters.AddWithValue("@EndDate", clsdoc.dateEndDate);
                    cmd.Parameters.AddWithValue("@ApprovalStatusCode", clsdoc.intApprovalStatusCode);

                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        var info = new clsRefund();

                        info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
                        info.ClientID                  = reader["ClientID"].ToString();
                        info.strProjectid              = reader["ProjectID"].ToString();
                        info.RefundDate                = Convert.ToDateTime(reader["RefundDate"].ToString());
                        info.Approved                  = Convert.ToBoolean(reader["Approve"].ToString());
                        info.Remarks                   = reader["Remarks"].ToString();
                        info.ApprovalStatusCode        = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
                        info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
                        info.ApprovalActionUser        = reader["ApprovalActionUser"].ToString();
                        info.ApprovalActionDate        = Convert.ToDateTime(reader["ApprovalActionDate"]);
                        info.CreatedBy                 = reader["CreatedBy"].ToString();
                        info.CreationDate              = Convert.ToDateTime(reader["CreationDate"]);
                        info.LastUpdateUser            = reader["LastUpdateUser"].ToString();
                        info.LastUpdateDate            = Convert.ToDateTime(reader["LastUpdateDate"]);
                        info.intPreviousStatusCode     = Convert.ToInt32(reader["PreviousStatusCode"].ToString());
                        info.StatusDescription         = reader["StatusDescription"].ToString();
                        info.id = Convert.ToInt32(reader["id"].ToString());

                        lst.Add(info);
                    }
                    conn.Close();
                }
            }
            return(lst);
        }
Example #3
0
        //public clsRefund GetRefundById(int id)
        //{
        //    clsRefund obj = new clsRefund();
        //    using (SqlConnection conn = new SqlConnection(strConn))
        //    {
        //        conn.Open();

        //        using (SqlCommand cmd = new SqlCommand("TMR_USP_GetRefundByID"))
        //        {
        //            cmd.CommandType = CommandType.StoredProcedure;
        //            cmd.Connection = conn;
        //            cmd.Parameters.AddWithValue("@id", id);


        //            SqlDataReader reader = cmd.ExecuteReader();

        //            while (reader.Read())
        //            {
        //                obj.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
        //                obj.ClientID = reader["ClientID"].ToString();
        //                obj.Remarks = reader["Remarks"].ToString();
        //                obj.RefundDate = Convert.ToDateTime(reader["RefundDate"]);
        //                obj.Approved = Convert.ToBoolean(reader["Approve"]);
        //                obj.id = Convert.ToInt32(reader["id"]);


        //            }
        //            conn.Close();
        //        }
        //    }
        //    return obj;
        //}

        #endregion

        public clsRefund GetRefundById(int id)
        {
            clsRefund info = new clsRefund();

            using (SqlConnection conn = new SqlConnection(strConn))
            {
                conn.Open();

                using (SqlCommand cmd = new SqlCommand("TMR_USP_GetRefundByID"))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Connection  = conn;
                    cmd.Parameters.AddWithValue("@id", id);

                    //cmd.Parameters.AddWithValue("@SizeCode", strSizeCode);
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        info.RegistrationOrBookingNo = reader["RegistrationNo"].ToString();
                        info.ClientID                  = reader["ClientID"].ToString();
                        info.strProjectid              = reader["ProjectID"].ToString();
                        info.RefundDate                = Convert.ToDateTime(reader["RefundDate"]);
                        info.Approved                  = Convert.ToBoolean(reader["Approve"].ToString());
                        info.Remarks                   = reader["Remarks"].ToString();
                        info.decDeduction              = Convert.ToDecimal(reader["Deduction"]);
                        info.decNet                    = Convert.ToDecimal(reader["Net"]);
                        info.decProfit                 = Convert.ToDecimal(reader["Profit"]);
                        info.decTax                    = Convert.ToDecimal(reader["TaxWithheld"]);
                        info.intPreviousStatusCode     = Convert.ToInt32(reader["PreviousStatusCode"]);
                        info.ApprovalStatusCode        = Convert.ToInt32(reader["ApprovalStatusCode"].ToString());
                        info.ApprovalStatusDescription = reader["ApprovalStatusDescription"].ToString();
                        info.ApprovalActionUser        = reader["ApprovalActionUser"].ToString();
                        info.ApprovalActionDate        = Convert.ToDateTime(reader["ApprovalActionDate"].ToString());
                        info.CreatedBy                 = reader["CreatedBy"].ToString();
                        info.CreationDate              = Convert.ToDateTime(reader["CreationDate"].ToString());
                        info.LastUpdateUser            = reader["LastUpdateUser"].ToString();
                        info.LastUpdateDate            = Convert.ToDateTime(reader["LastUpdateDate"].ToString());
                        info.id = Convert.ToInt32(reader["id"]);
                    }
                    conn.Close();
                }
            }
            return(info);
        }