public static bool Save_OrganizationAccountant(bool isOnlyDelete, OrganizationAccountantInfo obj, UserInfo objUserInfo, out string errormsg)
{
errormsg = "";
flag = false;
if (!Validations.ValidateDataType(obj.OrganizationCode, Validations.ValueType.AlphaNumericSpecialChar, false, "Organization", out errormsg))
{
return(false);
}
if (!Validations.ValidateDataType(obj.AccountantCode, Validations.ValueType.AlphaNumericSpecialChar, false, "Accountant", out errormsg))
{
return(false);
}
using (DBHelper dbhlper = new DBHelper("spMapOrganizationAccountantSave", true))
{
DBHelper.AddPparameter("@ID", obj.ID.Trim().Length > 0 ? obj.ID : "0", DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@AccountantCode", obj.AccountantCode, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@OrganizationCode", obj.OrganizationCode, DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@isOnlyDelete", (isOnlyDelete ? "Y" : "N"), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@UserCode", objUserInfo.UserCode.ToString().Trim(), DBHelper.param_types.Varchar);
DBHelper.AddPparameter("@ErrorMessage", errormsg, DBHelper.param_types.Varchar, 500, DBHelper.param_direction.Output);
return(DBHelper.Execute_NonQuery(out errormsg));
}
}
public ActionResult Save_OrganizationAccountant(string isOnlyDelete, string ID, string AccountantCode, string OrganizationCode)
{
using (Auth_Svc.UserAuthenticationServiceClient iGstSvc = new Auth_Svc.UserAuthenticationServiceClient())
{
if (Session["UserDetails"] != null && ((UserInfo)Session["UserDetails"]).UserType.ToString().Trim().ToUpper() == "R" && ((UserInfo)Session["UserDetails"]).OrganizationCode != null)
{
OrganizationCode = ((UserInfo)Session["UserDetails"]).OrganizationCode.Trim();
}
OrganizationAccountantInfo obj = new OrganizationAccountantInfo();
obj.OrganizationCode = OrganizationCode;
obj.AccountantCode = AccountantCode;
obj.ID = ID;
if (iGstSvc.Save_OrganizationAccountant(isOnlyDelete.Trim().ToUpper() == "Y", obj, ((UserInfo)Session["UserDetails"]), out ErrorMessage))
{
return(Json("Ok", JsonRequestBehavior.AllowGet));
}
}
return(Json(ErrorMessage, JsonRequestBehavior.AllowGet));
}
public static List <OrganizationAccountantInfo> GetList_OrganizationAccountant(string ID, string OrganizationCode, string AccountantCode, bool IsAudit)
{
using (DBHelper dbhlper = new DBHelper("[spMapOrganizationAccountantGet]"))
{
DBHelper.AddPparameter("@Mode", 0);
DBHelper.AddPparameter("@ID", ID.Trim().Length > 0 ? ID.Trim() : "0");
DBHelper.AddPparameter("@AccountantCode", AccountantCode);
DBHelper.AddPparameter("@OrganizationCode", OrganizationCode);
using (DataSet ds = DBHelper.Execute_Query())
{
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0)
{
List <OrganizationAccountantInfo> list = new List <OrganizationAccountantInfo>();
OrganizationAccountantInfo obj = null;
foreach (DataRow dr in ds.Tables[0].Rows)
{
obj = new OrganizationAccountantInfo();
obj.ID = dr["ID"].ToString();
obj.OrganizationCode = dr["OrganizationCode"].ToString();
obj.OrganizationName = dr["OrganizationName"].ToString();
obj.AccountantCode = dr["AccountantCode"].ToString();
obj.AccountantName = dr["AccountantName"].ToString();
list.Add(obj);
}
return(list);
}
}
}
var list1 = new List <OrganizationAccountantInfo>();
list1.Add(new OrganizationAccountantInfo());
return(list1);
}
public bool Save_OrganizationAccountant(bool isOnlyDelete, OrganizationAccountantInfo obj, UserInfo objUserInfo, out string errormsg)
{
return(wscalls.Save_OrganizationAccountant(isOnlyDelete, obj, objUserInfo, out errormsg));
}