public object TaskTransaction([FromBody] UserAuthParams userAuthParams)
{
string conn = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmdObj;
DataUtility du = new DataUtility();
cmdObj = new SqlCommand();
cmdObj.CommandText = "[GetTaskTrandaction]";
cmdObj.Parameters
.Add(new SqlParameter("@UserId", SqlDbType.NVarChar))
.Value = userAuthParams.authToken;
DataTable dtList = new DataTable();
List <TaskTransactionClass> TransactionDetailsList = new List <TaskTransactionClass>();
dtList = du.GetDataTableWithProc(cmdObj);
if (dtList.Rows.Count > 0)
{
foreach (DataRow dtrow in dtList.Rows)
{
TaskTransactionClass obj = new TaskTransactionClass();
obj.ActivityId = dtrow["TaskId"].ToString();
obj.TransactionNo = dtrow["TransactionNo"].ToString();
obj.ActivityName = dtrow["TaskName"].ToString();
obj.CustName = dtrow["CustName"].ToString();
obj.AssignToName = dtrow["VendorName"].ToString();
obj.AssestType = dtrow["assestType"].ToString();
obj.TaskType = dtrow["TaskType"].ToString();
obj.ContactNo = dtrow["ContactNo"].ToString();
obj.SpocName = dtrow["SpocName"].ToString();
obj.State = dtrow["State"].ToString();
TransactionDetailsList.Add(obj);
}
return(TransactionDetailsList);
}
else
{
var msg = new HttpResponseMessage(HttpStatusCode.NoContent)
{
ReasonPhrase = "No List Found"
};
return(msg);
}
}
public object GetMRemarks([FromBody] UserAuthParams userAuthParams)
{
string conn = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmdObj;
DataUtility du = new DataUtility();
cmdObj = new SqlCommand();
cmdObj.CommandText = "[GetManagerRemarks]";
cmdObj.Parameters
.Add(new SqlParameter("@UserId", SqlDbType.NVarChar))
.Value = userAuthParams.authToken;
DataTable dtList = new DataTable();
List <TransactionDetailsM> TransactionDetailsList = new List <TransactionDetailsM>();
dtList = du.GetDataTableWithProc(cmdObj);
if (dtList.Rows.Count > 0)
{
foreach (DataRow dtrow in dtList.Rows)
{
TransactionDetailsM obj = new TransactionDetailsM();
obj.TransactionNo = dtrow["TransactionNo"].ToString();
obj.AssetsId = dtrow["AssestId"].ToString();
obj.ActivityId = dtrow["Activity"].ToString();
obj.Status = dtrow["Status"].ToString();
obj.Remarks = dtrow["ManagerRemarks"].ToString();
TransactionDetailsList.Add(obj);
}
return(TransactionDetailsList);
}
else
{
var msg = new HttpResponseMessage(HttpStatusCode.NoContent)
{
ReasonPhrase = "No List Found"
};
return(msg);
}
}
public object UserLogin([FromBody] UserAuthParams userAuthParams)
{
string conn = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmdObj;
DataUtility du = new DataUtility();
cmdObj = new SqlCommand();
cmdObj.CommandText = "[LoginMaster]";
cmdObj.Parameters
.Add(new SqlParameter("@UserId", SqlDbType.NVarChar))
.Value = userAuthParams.authToken;
cmdObj.Parameters
.Add(new SqlParameter("@Password", SqlDbType.NVarChar))
.Value = userAuthParams.Password;
DataTable dtList = new DataTable();
List <UserDetails> UserDetailsList = new List <UserDetails>();
dtList = du.GetDataTableWithProc(cmdObj);
if (dtList.Rows.Count > 0)
{
UserDetails obj = new UserDetails();
obj.UserId = dtList.Rows[0][0].ToString();
UserDetailsList.Add(obj);
return(UserDetailsList);
}
else
{
var msg = new HttpResponseMessage(HttpStatusCode.NoContent)
{
ReasonPhrase = "No List Found"
};
return(msg);
}
}
public object GetTaskActivity([FromBody] UserAuthParams userAuthParams)
{
string conn = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
SqlCommand cmdObj;
DataUtility du = new DataUtility();
cmdObj = new SqlCommand();
cmdObj.CommandText = "[GetAllTaskTransaction]";
cmdObj.Parameters
.Add(new SqlParameter("@UserId", SqlDbType.NVarChar))
.Value = userAuthParams.authToken;
DataTable dtList = new DataTable();
List <TransactionDetails> TransactionDetailsList = new List <TransactionDetails>();
dtList = du.GetDataTableWithProc(cmdObj);
if (dtList.Rows.Count > 0)
{
foreach (DataRow dtrow in dtList.Rows)
{
TransactionDetails obj = new TransactionDetails();
obj.TransactionNo = dtrow["TransactionNo"].ToString();
obj.AssetsId = dtrow["AssestId"].ToString();
obj.ActivityId = dtrow["Activity"].ToString();
obj.ActivityName = dtrow["TaskName"].ToString();
obj.CustId = dtrow["CustName"].ToString();
obj.CustName = dtrow["CustName"].ToString();
obj.AssignToId = dtrow["AssignToNew"].ToString();
obj.AssignToName = dtrow["Name"].ToString();
obj.AssignmentDate = dtrow["AssignDateNew"].ToString();
obj.HostName = dtrow["HostName"].ToString();
obj.BImage = dtrow["BImage"].ToString();
obj.Aimage = dtrow["AImage"].ToString();
obj.completedby = dtrow["CompleteBy"].ToString();
obj.actiondate = dtrow["ActDate"].ToString();
obj.Description = dtrow["Description"].ToString();
obj.DND = dtrow["DND"].ToString();
obj.FaultyDesc = dtrow["FaultyDesc"].ToString();
TransactionDetailsList.Add(obj);
}
return(TransactionDetailsList);
}
else
{
var msg = new HttpResponseMessage(HttpStatusCode.NoContent)
{
ReasonPhrase = "No List Found"
};
return(msg);
}
}
