public ServantModel GetServantDetails(int id)
{
List <ServantModel> partLst = new List <ServantModel>();
ServantModel part = new ServantModel();
//string query = "Select * from [dbo].[CLPParticipant] WHERE Memberid = " + id;
string query = "Select prt.id, prt.memberId, prt.CLPid as CLPId, prt.ServiceId as ServiceId, mem.LastName + ', ' + mem.FirstName as name from [dbo].[CLPServants] prt " +
"Inner Join[dbo].[Member] mem ON prt.memberId = mem.id WHERE prt.memberId = " + id;
DataSet ds = Connection.connectSQLServerQuery(query);
partLst = BaseReflection.DatasetBDToObjectList <ServantModel>(ds);
if (partLst.Count > 0)
{
part = new ServantModel
{
id = partLst[0].id,
memberId = partLst[0].memberId,
name = partLst[0].name,
CLPId = partLst[0].CLPId,
ServiceId = partLst[0].ServiceId
};
}
//part.MemberList = ParticipantData.GetMemberParticipantListModify();
//GenericList model = (GroupList != null && GroupList.Count > 0) ? GroupList[0] : null;
return(part);
}
public ActionResult SaveServant(ServantModel model)
{
ServantData MemRepo = new ServantData();
model.DateEntered = DateTime.Now;
model.ModifiedDate = DateTime.Now;
model.EnteredBy = 1; //user
model.ModifiedBy = 1; //user
if (ModelState.IsValid)
{
ResponseModel isSave = MemRepo.SaveServant(model);
if (isSave.status == 1)
{
Connection.CommitTransaction();
Connection.CloseConnection();
return(Json(new { status = true, code = 2, msg = "Successfuly Created." }, JsonRequestBehavior.AllowGet));
}
else
{
Connection.RollbackTransaction();
Connection.CloseConnection();
return(Json(new { status = false, code = 0, msg = "Something went wrong." }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { status = false, code = 0, msg = "Something went wrong." }, JsonRequestBehavior.AllowGet));
}
}
public ResponseModel SaveServant(ServantModel modl)
{
ResponseModel resp = new ResponseModel();
string sqlQuery = string.Empty;
try
{
using (SqlConnection db = new SqlConnection(Connection.connString))
{
sqlQuery = "Insert Into [dbo].[CLPServants] ([memberId],[ServiceId],[CLPid], [DateEntered],[EnteredBy],[ModifiedDate],[ModifiedBy])" +
"Values(@memberId, @ServiceId, @CLPid, @DateEntered, @EnteredBy, @ModifiedDate, @ModifiedBy)";
var x = db.Execute(sqlQuery, new
{
memberId = modl.memberId,
ServiceId = modl.ServiceId,
CLPid = modl.CLPId,
DateEntered = modl.DateEntered,
EnteredBy = modl.EnteredBy,
ModifiedDate = modl.ModifiedDate,
ModifiedBy = modl.ModifiedBy
});
}
resp.status = 1;
resp.msg = "Item inserted - Success";
}
catch (Exception ex)
{
resp.status = 0;
resp.msg = "Item inserted - Failed : " + ex.Message;
}
return(resp);
}
// GET: Servant
public ActionResult Index()
{
ServantModel model = new ServantModel();
model.MemberList = ServantData.GetMemberList();
model.ServiceList = ServantData.GetServiceList();
model.CLPList = ServantData.GetCLPList();
return(View(model));
}
public ActionResult ModifyServant(int id)
{
ServantData partRepo = new ServantData();
ServantModel model = partRepo.GetServantDetails(id);
if (model.id > 0)
{
return(Json(new { status = true, result = model, msg = "Successfuly Created." }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { status = false, code = 0, msg = "Something went wrong." }, JsonRequestBehavior.AllowGet));
}
}
private void HandleCalendarDay(DateTime day)
{
ServantModel model = AmbitionApp.GetModel <ServantModel>();
ServantVO seamstress;
if (model.Servants.TryGetValue(ServantConsts.CLOTHIER, out seamstress) && seamstress.Type == ServantConsts.SEAMSTRESS)
{
myText.text = AmbitionApp.GetModel <InventoryModel>().NextStyle;
}
else
{
myText.text = "Unknown";
}
}
public static List <ServantModel> GetServantsList(int?id)
{
string query = string.Empty;
List <ServantModel> servant = new List <ServantModel>();
query = " SELECT ser.id, ser.memberId, mem.LastName + ', ' + mem.FirstName as name, vc.ServantTask as ServiceName " +
"FROM[dbo].[CLPServants] ser " +
"INNER JOIN[dbo].[Member] mem ON ser.memberId = mem.id " +
"INNER JOIN[dbo].[CLPService] vc ON ser.ServiceId = vc.id";
DataSet ds = Connection.connectSQLServerQuery(query);
servant = BaseReflection.DatasetBDToObjectList <ServantModel>(ds);
ServantModel model = (servant != null && servant.Count > 0) ? servant[0] : null;
return(servant);
}
// Use this for initialization
void Awake()
{
_model = AmbitionApp.GetModel <ServantModel>();
GenerateInventoryButtons();
selectedServant = null;
}
