public static bool Save_BankTransaction(bool isOnlyDelete, BankTransactionInfo objBankInfo, UserInfo objUserInfo, out string errormsg)
{
errormsg = "";
#region Validations
if (!Validations.ValidateDataType(objBankInfo.Products, Validations.ValueType.AlphaNumericSpecialChar, true, "Products", out errormsg))
{
return(false);
}
if (!Validations.ValidateDataType(objBankInfo.CustomerId, Validations.ValueType.Integer, true, "Customer/Supplier", out errormsg))
{
return(false);
}
if (!Validations.ValidateDataType(objBankInfo.Tax, Validations.ValueType.Numeric, true, "Tax", out errormsg))
{
return(false);
}
#endregion
using (DBHelper dbhlper = new DBHelper("[spBankTransactionsSave]", true))
{
DBHelper.AddPparameter("@BankTransactionId", objBankInfo.Id.Trim().Length > 0 ? Convert.ToInt32(objBankInfo.Id) : 0, DBHelper.param_types.Int);
DBHelper.AddPparameter("@Products", objBankInfo.Products, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@CustomerId", objBankInfo.CustomerId, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@IsSellExpense", objBankInfo.IsSellExpense, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@Tax", objBankInfo.Tax, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? 'Y' : 'N'), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@NewDatauniqueID", 0, DBHelper.param_types.BigInt, 50, DBHelper.param_direction.Output);
DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output);
return(DBHelper.Execute_NonQuery(out errormsg));
}
}
public ActionResult Save_BankTransaction(string isOnlyDelete, string OrganizationCode, string Id, string Products, string CustomerId, string IsSellExpense, string Tax, string IsActive)
{
if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null)
{
OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim();
}
using (Master_Svc.MasterServiceClient iGstSvc = new Master_Svc.MasterServiceClient())
{
BankTransactionInfo objBank = new BankTransactionInfo();
objBank.Id = Id;
objBank.ProductIds = Products;
objBank.CustomerId = CustomerId;
objBank.Tax = Tax;
objBank.IsSellExpense = IsSellExpense;
objBank.OrganizationCode = OrganizationCode;
objBank.IsActive = IsActive.Trim().ToUpper() == "Y";
if (iGstSvc.Save_BankTransaction(isOnlyDelete.Trim().ToUpper() == "Y", objBank, ((UserInfo)Session["UserDetails"]), out ErrorMessage))
{
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
}
return(Json(ErrorMessage, JsonRequestBehavior.AllowGet));
}
public Task <BankTransactionInfo> PostTransaction(Payment payment)
{
var transactionInfo = new BankTransactionInfo
{
BankTransactionId = Guid.NewGuid(),
Status = PaymentStatus.Approved,
ErrorCode = string.Empty,
Message = string.Empty
};
if (payment.Amount == 717)
{
transactionInfo.Message = "Error";
transactionInfo.ErrorCode = "ErrorCode";
transactionInfo.Status = PaymentStatus.Declined;
}
if (payment.Amount == 500)
{
transactionInfo.Message = "Error";
transactionInfo.ErrorCode = "ErrorCode";
transactionInfo.Status = PaymentStatus.Error;
}
return(Task.FromResult(transactionInfo));
}
public static List <BankTransactionInfo> GetList_BankTransaction(string BankTransactionID, string OrganizationCode, bool IsActive)
{
using (DBHelper dbhlper = new DBHelper("[spBankTransactionsGet]"))
{
DBHelper.AddPparameter("@ID", BankTransactionID);
DBHelper.AddPparameter("@OrganizationCode", OrganizationCode);
using (DataSet ds = DBHelper.Execute_Query())
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <BankTransactionInfo> list = new List <BankTransactionInfo>();
BankTransactionInfo obj = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new BankTransactionInfo();
obj.OrganizationCode = dr["OrganizationCode"].ToString();
obj.OrganizationName = dr["OrganizationName"].ToString();
obj.TransactionID = dr["TransactionID"].ToString().Trim();
obj.TransactionDate = Convert.ToDateTime(dr["TransactionDate"].ToString()).ToString("dd MMM yy");
obj.Id = dr["Id"].ToString();
obj.DatauniqueID = dr["DatauniqueID"].ToString();
obj.Debit = dr["Debit"].ToString();
obj.Credit = dr["Credit"].ToString();
obj.ChqNo = dr["ChqNo"].ToString();
obj.Balance = dr["Balance"].ToString();
obj.Particulars = dr["Particulars"].ToString();
obj.IsSellExpense = dr["IsSellExpense"].ToString();
obj.InitBr = dr["InitBr"].ToString();
obj.CustomerId = dr["CustomerId"].ToString();
obj.CustomerName = dr["CustomerName"].ToString();
obj.ProductIds = dr["ProductIds"].ToString();
obj.Products = dr["Products"].ToString();
obj.Tax = dr["Tax"].ToString();
obj.LastModifiedOn = Convert.ToDateTime(dr["LastModifiedOn"]);
obj.LastModifiedBy = dr["LastModifiedBy"].ToString();
obj.ActivityType = dr["ActivityType"].ToString();
obj.IsActive = dr["IsActive"].ToString().Trim().ToUpper() == "Y";
list.Add(obj);
}
return(list);
}
}
}
return(null);
}
public ActionResult GetDetails_BankTransaction(string BankTransactionID, string OrganizationCode)
{
if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null)
{
OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim();
}
using (Master_Svc.MasterServiceClient iGstSvc = new Master_Svc.MasterServiceClient())
{
BankTransactionInfo obj = iGstSvc.GetDetails_BankTransaction(BankTransactionID, OrganizationCode, true);
ViewBag.OrganizationProducts = CommonMethods.ListOrganizationProducts(obj.OrganizationCode, obj.ProductIds);
ViewBag.Customers = CommonMethods.ListCustomer(obj.OrganizationCode, obj.CustomerId);
ViewBag.Banks = CommonMethods.ListBanks(obj.OrganizationCode, "");
return(PartialView("~/Views/MasterPages/BankTransactionDetails.cshtml", obj));
}
}
public bool Save_BankTransaction(bool isOnlyDelete, BankTransactionInfo objBankInfo, UserInfo objUserInfo, out string errormsg)
{
return(wscalls.Save_BankTransaction(isOnlyDelete, objBankInfo, objUserInfo, out errormsg));
}
